1
1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
2
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
4
* Copyright (C) 2008-2009 Sun Microsystems
4
* Copyright (C) 2008-2009 Sun Microsystems, Inc.
6
6
* This program is free software; you can redistribute it and/or modify
7
7
* it under the terms of the GNU General Public License as published by
42
uint32_t calc_week(DRIZZLE_TIME *l_time, uint32_t week_behaviour, uint32_t *year)
42
uint32_t calc_week(type::Time *l_time, uint32_t week_behaviour, uint32_t *year)
45
45
uint32_t daynr= calc_daynr(l_time->year,l_time->month,l_time->day);
108
108
if (day_of_year > 31+28)
111
if (day_of_year == 31+28)
112
leap_day=1; /* Handle leapyears leapday */
111
if (day_of_year == 31+28)
112
leap_day=1; /* Handle leapyears leapday */
116
116
for (month_pos= days_in_month ;
117
day_of_year > (uint32_t) *month_pos ;
118
day_of_year-= *(month_pos++), (*ret_month)++)
117
day_of_year > (uint32_t) *month_pos ;
118
day_of_year-= *(month_pos++), (*ret_month)++)
121
121
*ret_day=day_of_year+leap_day;
127
enum enum_drizzle_timestamp_type
128
str_to_datetime_with_warn(const char *str,
130
DRIZZLE_TIME *l_time,
127
type::timestamp_t str_to_datetime_with_warn(const char *str,
134
enum enum_drizzle_timestamp_type ts_type;
133
type::timestamp_t ts_type;
135
134
Session *session= current_session;
137
136
ts_type= str_to_datetime(str, length, l_time,
139
138
(MODE_INVALID_DATES |
140
139
MODE_NO_ZERO_DATE))),
142
if (was_cut || ts_type <= DRIZZLE_TIMESTAMP_ERROR)
141
if (was_cut || ts_type <= type::DRIZZLE_TIMESTAMP_ERROR)
143
142
make_truncated_value_warning(session, DRIZZLE_ERROR::WARN_LEVEL_WARN,
144
143
str, length, ts_type, NULL);
150
str_to_time_with_warn(const char *str, uint32_t length, DRIZZLE_TIME *l_time)
149
str_to_time_with_warn(const char *str, uint32_t length, type::Time *l_time)
153
152
bool ret_val= str_to_time(str, length, l_time, &warning);
154
153
if (ret_val || warning)
155
154
make_truncated_value_warning(current_session, DRIZZLE_ERROR::WARN_LEVEL_WARN,
156
str, length, DRIZZLE_TIMESTAMP_TIME, NULL);
155
str, length, type::DRIZZLE_TIMESTAMP_TIME, NULL);
161
void localtime_to_TIME(DRIZZLE_TIME *to, struct tm *from)
165
to->year= (int) ((from->tm_year+1900) % 10000);
166
to->month= (int) from->tm_mon+1;
167
to->day= (int) from->tm_mday;
168
to->hour= (int) from->tm_hour;
169
to->minute= (int) from->tm_min;
170
to->second= (int) from->tm_sec;
173
void make_date(const DRIZZLE_TIME *l_time, String *str)
175
str->alloc(MAX_DATE_STRING_REP_LENGTH);
176
uint32_t length= (uint32_t) my_date_to_str(l_time, str->c_ptr());
178
str->set_charset(&my_charset_bin);
182
void make_datetime(const DRIZZLE_TIME *l_time, String *str)
184
str->alloc(MAX_DATE_STRING_REP_LENGTH);
185
uint32_t length= (uint32_t) my_datetime_to_str(l_time, str->c_ptr());
187
str->set_charset(&my_charset_bin);
191
160
void make_truncated_value_warning(Session *session,
192
161
DRIZZLE_ERROR::enum_warning_level level,
193
162
const char *str_val,
194
163
uint32_t str_length,
195
enum enum_drizzle_timestamp_type time_type,
164
type::timestamp_t time_type,
196
165
const char *field_name)
198
167
char warn_buff[DRIZZLE_ERRMSG_SIZE];
204
173
str[str_length]= 0; // Ensure we have end 0 for snprintf
206
175
switch (time_type) {
207
case DRIZZLE_TIMESTAMP_DATE:
210
case DRIZZLE_TIMESTAMP_TIME:
213
case DRIZZLE_TIMESTAMP_DATETIME: // FALLTHROUGH
215
type_str= "datetime";
176
case type::DRIZZLE_TIMESTAMP_DATE:
180
case type::DRIZZLE_TIMESTAMP_TIME:
184
case type::DRIZZLE_TIMESTAMP_DATETIME: // FALLTHROUGH
186
type_str= "datetime";
220
192
cs->cset->snprintf(cs, warn_buff, sizeof(warn_buff),
227
if (time_type > DRIZZLE_TIMESTAMP_ERROR)
199
if (time_type > type::DRIZZLE_TIMESTAMP_ERROR)
228
201
cs->cset->snprintf(cs, warn_buff, sizeof(warn_buff),
229
202
ER(ER_TRUNCATED_WRONG_VALUE),
230
203
type_str, str.c_ptr());
232
207
cs->cset->snprintf(cs, warn_buff, sizeof(warn_buff),
233
208
ER(ER_WRONG_VALUE), type_str, str.c_ptr());
235
211
push_warning(session, level,
236
212
ER_TRUNCATED_WRONG_VALUE, warn_buff);
241
calc_time_diff(DRIZZLE_TIME *l_time1, DRIZZLE_TIME *l_time2, int l_sign, int64_t *seconds_out,
217
calc_time_diff(type::Time *l_time1, type::Time *l_time2, int l_sign, int64_t *seconds_out,
242
218
long *microseconds_out)
250
226
the second argument should be TIMESTAMP_TIME also.
251
227
We should check it before calc_time_diff call.
253
if (l_time1->time_type == DRIZZLE_TIMESTAMP_TIME) // Time value
229
if (l_time1->time_type == type::DRIZZLE_TIMESTAMP_TIME) // Time value
254
230
days= (long)l_time1->day - l_sign * (long)l_time2->day;
257
233
days= calc_daynr((uint32_t) l_time1->year,
258
(uint32_t) l_time1->month,
259
(uint32_t) l_time1->day);
260
if (l_time2->time_type == DRIZZLE_TIMESTAMP_TIME)
234
(uint32_t) l_time1->month,
235
(uint32_t) l_time1->day);
236
if (l_time2->time_type == type::DRIZZLE_TIMESTAMP_TIME)
261
237
days-= l_sign * (long)l_time2->day;
263
239
days-= l_sign*calc_daynr((uint32_t) l_time2->year,
264
(uint32_t) l_time2->month,
265
(uint32_t) l_time2->day);
240
(uint32_t) l_time2->month,
241
(uint32_t) l_time2->day);
268
244
microseconds= ((int64_t)days*86400L +
269
245
(int64_t)(l_time1->hour*3600L +
270
l_time1->minute*60L +
246
l_time1->minute*60L +
272
248
l_sign*(int64_t)(l_time2->hour*3600L +
273
l_time2->minute*60L +
274
l_time2->second)) * 1000000L +
275
(int64_t)l_time1->second_part -
276
l_sign*(int64_t)l_time2->second_part;
249
l_time2->minute*60L +
250
l_time2->second)) * 1000000L +
251
(int64_t)l_time1->second_part -
252
l_sign*(int64_t)l_time2->second_part;
279
255
if (microseconds < 0)