17
17
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
21
#include "drizzled/temporal.h"
22
#include "drizzled/error.h"
23
#include "drizzled/calendar.h"
24
#include "drizzled/function/time/dayofyear.h"
25
#include "drizzled/internal/my_sys.h"
20
#include <drizzled/server_includes.h>
22
#include <drizzled/function/time/dayofyear.h>
30
24
int64_t Item_func_dayofyear::val_int()
34
if (args[0]->is_null())
36
/* For NULL argument, we return a NULL result */
28
if (get_arg0_date(<ime,TIME_NO_ZERO_DATE))
41
/* Grab the first argument as a DateTime object */
43
Item_result arg0_result_type= args[0]->result_type();
45
switch (arg0_result_type)
49
* For doubles supplied, interpret the arg as a string,
50
* so intentionally fall-through here...
51
* This allows us to accept double parameters like
52
* 19971231235959.01 and interpret it the way MySQL does:
53
* as a TIMESTAMP-like thing with a microsecond component.
54
* Ugh, but need to keep backwards-compat.
58
char buff[DRIZZLE_MAX_LENGTH_DATETIME_AS_STRING];
59
String tmp(buff,sizeof(buff), &my_charset_utf8_bin);
60
String *res= args[0]->val_str(&tmp);
62
if (res && (res != &tmp))
67
if (! temporal.from_string(tmp.c_ptr(), tmp.length()))
70
* Could not interpret the function argument as a temporal value,
71
* so throw an error and return 0
73
my_error(ER_INVALID_DATETIME_VALUE, MYF(0), tmp.c_ptr());
79
if (temporal.from_int64_t(args[0]->val_int()))
81
/* Intentionally fall-through on invalid conversion from integer */
85
* Could not interpret the function argument as a temporal value,
86
* so throw an error and return 0
89
char buff[DRIZZLE_MAX_LENGTH_DATETIME_AS_STRING];
90
String tmp(buff,sizeof(buff), &my_charset_utf8_bin);
93
res= args[0]->val_str(&tmp);
95
if (res && (res != &tmp))
100
my_error(ER_INVALID_DATETIME_VALUE, MYF(0), tmp.c_ptr());
104
return (int64_t) julian_day_number_from_gregorian_date(temporal.years(), temporal.months(), temporal.days())
105
- julian_day_number_from_gregorian_date(temporal.years(), 1, 1) + 1;
30
return (int64_t) calc_daynr(ltime.year,ltime.month,ltime.day) -
31
calc_daynr(ltime.year,1,1) + 1;
108
} /* namespace drizzled */