drizzle
C++ MySQL-protocol-compatible database server
Loading...
Searching...
No Matches
dayofyear.cc
1/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2 * vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
3 *
4 * Copyright (C) 2008 Sun Microsystems, Inc.
5 *
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.
9 *
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.
14 *
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
18 */
19
20#include <config.h>
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>
26
27namespace drizzled
28{
29
31{
32 assert(fixed);
33
34 if (args[0]->is_null())
35 {
36 /* For NULL argument, we return a NULL result */
37 null_value= true;
38 return 0;
39 }
40
41 /* Grab the first argument as a DateTime object */
42 DateTime temporal;
43 Item_result arg0_result_type= args[0]->result_type();
44
45 switch (arg0_result_type)
46 {
47 case DECIMAL_RESULT:
48 /*
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.
55 */
56 case STRING_RESULT:
57 {
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);
61
62 if (res && (res != &tmp))
63 {
64 tmp.copy(*res);
65 }
66
67 if (! temporal.from_string(tmp.c_ptr(), tmp.length()))
68 {
69 /*
70 * Could not interpret the function argument as a temporal value,
71 * so throw an error and return 0
72 */
73 my_error(ER_INVALID_DATETIME_VALUE, MYF(0), tmp.c_ptr());
74 return 0;
75 }
76 }
77 break;
78 case INT_RESULT:
79 if (temporal.from_int64_t(args[0]->val_int()))
80 break;
81 /* Intentionally fall-through on invalid conversion from integer */
82 /* fallthrough */
83 default:
84 {
85 /*
86 * Could not interpret the function argument as a temporal value,
87 * so throw an error and return 0
88 */
89 null_value= true;
90 char buff[DRIZZLE_MAX_LENGTH_DATETIME_AS_STRING];
91 String tmp(buff,sizeof(buff), &my_charset_utf8_bin);
92 String *res;
93
94 res= args[0]->val_str(&tmp);
95
96 if (res && (res != &tmp))
97 {
98 tmp.copy(*res);
99 }
100
101 my_error(ER_INVALID_DATETIME_VALUE, MYF(0), tmp.c_ptr());
102 return 0;
103 }
104 }
105 return (int64_t) julian_day_number_from_gregorian_date(temporal.years(), temporal.months(), temporal.days())
106 - julian_day_number_from_gregorian_date(temporal.years(), 1, 1) + 1;
107}
108
109} /* namespace drizzled */
bool from_string(const char *from, size_t from_len)
Definition temporal.cc:122
bool from_int64_t(const int64_t from, bool convert)
Definition temporal.cc:1106
bool fixed
Definition item.h:122
bool null_value
Definition item.h:124
uint32_t months() const
Definition temporal.h:146
uint32_t years() const
Definition temporal.h:150
uint32_t days() const
Definition temporal.h:142
TODO: Rename this file - func.h is stupid.
int64_t julian_day_number_from_gregorian_date(uint32_t year, uint32_t month, uint32_t day)
Definition calendar.cc:93