574.3.17
by Lee
moving functions from item_timefunc to functions/time directory |
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
|
|
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 <drizzled/server_includes.h> |
|
21 |
#include CSTDINT_H
|
|
670.1.20
by Monty Taylor
Renamed functions to function... everything else is singular. |
22 |
#include <drizzled/function/time/make_datetime.h> |
574.3.17
by Lee
moving functions from item_timefunc to functions/time directory |
23 |
|
24 |
/**
|
|
25 |
@todo
|
|
26 |
OPTIMIZATION
|
|
27 |
- Replace the switch with a function that should be called for each
|
|
28 |
date type.
|
|
29 |
- Remove sprintf and opencode the conversion, like we do in
|
|
30 |
Field_datetime.
|
|
31 |
||
32 |
The reason for this functions existence is that as we don't have a
|
|
33 |
way to know if a datetime/time value has microseconds in them
|
|
34 |
we are now only adding microseconds to the output if the
|
|
35 |
value has microseconds.
|
|
36 |
||
37 |
We can't use a standard make_date_time() for this as we don't know
|
|
38 |
if someone will use %f in the format specifier in which case we would get
|
|
39 |
the microseconds twice.
|
|
40 |
*/
|
|
41 |
||
42 |
bool make_datetime(date_time_format_types format, DRIZZLE_TIME *ltime, |
|
43 |
String *str) |
|
44 |
{
|
|
45 |
char *buff; |
|
46 |
const CHARSET_INFO * const cs= &my_charset_bin; |
|
47 |
uint32_t length= MAX_DATE_STRING_REP_LENGTH; |
|
48 |
||
49 |
if (str->alloc(length)) |
|
50 |
return 1; |
|
51 |
buff= (char*) str->ptr(); |
|
52 |
||
53 |
switch (format) { |
|
54 |
case TIME_ONLY: |
|
55 |
length= cs->cset->snprintf(cs, buff, length, "%s%02d:%02d:%02d", |
|
56 |
ltime->neg ? "-" : "", |
|
57 |
ltime->hour, ltime->minute, ltime->second); |
|
58 |
break; |
|
59 |
case TIME_MICROSECOND: |
|
60 |
length= cs->cset->snprintf(cs, buff, length, "%s%02d:%02d:%02d.%06ld", |
|
61 |
ltime->neg ? "-" : "", |
|
62 |
ltime->hour, ltime->minute, ltime->second, |
|
63 |
ltime->second_part); |
|
64 |
break; |
|
65 |
case DATE_ONLY: |
|
66 |
length= cs->cset->snprintf(cs, buff, length, "%04d-%02d-%02d", |
|
67 |
ltime->year, ltime->month, ltime->day); |
|
68 |
break; |
|
69 |
case DATE_TIME: |
|
70 |
length= cs->cset->snprintf(cs, buff, length, |
|
71 |
"%04d-%02d-%02d %02d:%02d:%02d", |
|
72 |
ltime->year, ltime->month, ltime->day, |
|
73 |
ltime->hour, ltime->minute, ltime->second); |
|
74 |
break; |
|
75 |
case DATE_TIME_MICROSECOND: |
|
76 |
length= cs->cset->snprintf(cs, buff, length, |
|
77 |
"%04d-%02d-%02d %02d:%02d:%02d.%06ld", |
|
78 |
ltime->year, ltime->month, ltime->day, |
|
79 |
ltime->hour, ltime->minute, ltime->second, |
|
80 |
ltime->second_part); |
|
81 |
break; |
|
82 |
}
|
|
83 |
||
84 |
str->length(length); |
|
85 |
str->set_charset(cs); |
|
86 |
return 0; |
|
87 |
}
|
|
88 |