1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
4
* Copyright (C) 2008 Sun Microsystems
6
* This program is free software; you can redistribute it and/or modify
7
* it under the terms of the GNU General Public License as published by
8
* the Free Software Foundation; version 2 of the License.
10
* This program is distributed in the hope that it will be useful,
11
* but WITHOUT ANY WARRANTY; without even the implied warranty of
12
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13
* GNU General Public License for more details.
15
* You should have received a copy of the GNU General Public License
16
* along with this program; if not, write to the Free Software
17
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
20
#include "drizzled/server_includes.h"
22
#include "drizzled/temporal.h"
23
#include "drizzled/error.h"
24
#include "drizzled/function/time/weekday.h"
26
int64_t Item_func_weekday::val_int()
30
if (args[0]->is_null())
32
/* For NULL argument, we return a NULL result */
37
/* Grab the first argument as a DateTime object */
38
drizzled::DateTime temporal;
39
Item_result arg0_result_type= args[0]->result_type();
41
switch (arg0_result_type)
45
* For doubles supplied, interpret the arg as a string,
46
* so intentionally fall-through here...
47
* This allows us to accept double parameters like
48
* 19971231235959.01 and interpret it the way MySQL does:
49
* as a TIMESTAMP-like thing with a microsecond component.
50
* Ugh, but need to keep backwards-compat.
54
char buff[DRIZZLE_MAX_LENGTH_DATETIME_AS_STRING];
55
String tmp(buff,sizeof(buff), &my_charset_utf8_bin);
56
String *res= args[0]->val_str(&tmp);
57
if (! temporal.from_string(res->c_ptr(), res->length()))
60
* Could not interpret the function argument as a temporal value,
61
* so throw an error and return 0
63
my_error(ER_INVALID_DATETIME_VALUE, MYF(0), res->c_ptr());
69
if (temporal.from_int64_t(args[0]->val_int()))
71
/* Intentionally fall-through on invalid conversion from integer */
75
* Could not interpret the function argument as a temporal value,
76
* so throw an error and return 0
79
char buff[DRIZZLE_MAX_LENGTH_DATETIME_AS_STRING];
80
String tmp(buff,sizeof(buff), &my_charset_utf8_bin);
83
res= args[0]->val_str(&tmp);
85
my_error(ER_INVALID_DATETIME_VALUE, MYF(0), res->c_ptr());
89
/* @TODO This ODBC thing is a complete hack. Fix it. */
90
bool sunday_first= odbc_type;
91
int64_t julian_day= julian_day_number_from_gregorian_date(temporal.years(), temporal.months(), temporal.days());
92
return (int64_t) day_of_week(julian_day, sunday_first) + test(odbc_type);