Debian Codegraph @

mysql-test/suite/engines/funcs/r/date_function.result

raw
1 DROP TABLE IF EXISTS t3;
2 SET sql_mode='NO_ENGINE_SUBSTITUTION';
3 CREATE TABLE t3(c1 DATE NOT NULL);
4 INSERT INTO t3 VALUES('1000-01-01');
5 INSERT INTO t3 VALUES('1999-12-31');
6 INSERT INTO t3 VALUES('2000-01-01');
7 INSERT INTO t3 VALUES('2006-12-25');
8 INSERT INTO t3 VALUES('2008-02-29');
9 SELECT DATE(c1) FROM t3;
10 DATE(c1)
11 1000-01-01
12 1999-12-31
13 2000-01-01
14 2006-12-25
15 2008-02-29
16 DROP TABLE t3;
17 CREATE TABLE t3(c1 DATETIME NOT NULL);
18 INSERT INTO t3 VALUES('1000-01-01');
19 INSERT INTO t3 VALUES('1999-12-31');
20 INSERT INTO t3 VALUES('2000-01-01');
21 INSERT INTO t3 VALUES('2006-12-25');
22 INSERT INTO t3 VALUES('2008-02-29');
23 SELECT DATE(c1) FROM t3;
24 DATE(c1)
25 1000-01-01
26 1999-12-31
27 2000-01-01
28 2006-12-25
29 2008-02-29
30 DROP TABLE t3;
31 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
32 INSERT INTO t3 VALUES('1000-01-01');
33 Warnings:
34 Warning 1264 Out of range value for column 'c1' at row 1
35 INSERT INTO t3 VALUES('1999-12-31');
36 INSERT INTO t3 VALUES('2000-01-01');
37 INSERT INTO t3 VALUES('2006-12-25');
38 INSERT INTO t3 VALUES('2008-02-29');
39 SELECT DATE(c1) FROM t3;
40 DATE(c1)
41 0000-00-00
42 1999-12-31
43 2000-01-01
44 2006-12-25
45 2008-02-29
46 DROP TABLE t3;
47 CREATE TABLE t3(c1 DATE NOT NULL);
48 INSERT INTO t3 VALUES('1000-01-01');
49 INSERT INTO t3 VALUES('1999-12-31');
50 INSERT INTO t3 VALUES('2000-01-01');
51 INSERT INTO t3 VALUES('2006-12-25');
52 INSERT INTO t3 VALUES('2008-02-29');
53 SELECT DAYNAME(c1) FROM t3;
54 DAYNAME(c1)
55 Wednesday
56 Friday
57 Saturday
58 Monday
59 Friday
60 DROP TABLE t3;
61 CREATE TABLE t3(c1 DATETIME NOT NULL);
62 INSERT INTO t3 VALUES('1000-01-01');
63 INSERT INTO t3 VALUES('1999-12-31');
64 INSERT INTO t3 VALUES('2000-01-01');
65 INSERT INTO t3 VALUES('2006-12-25');
66 INSERT INTO t3 VALUES('2008-02-29');
67 SELECT DAYNAME(c1) FROM t3;
68 DAYNAME(c1)
69 Wednesday
70 Friday
71 Saturday
72 Monday
73 Friday
74 DROP TABLE t3;
75 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
76 INSERT INTO t3 VALUES('1000-01-01');
77 Warnings:
78 Warning 1264 Out of range value for column 'c1' at row 1
79 INSERT INTO t3 VALUES('1999-12-31');
80 INSERT INTO t3 VALUES('2000-01-01');
81 INSERT INTO t3 VALUES('2006-12-25');
82 INSERT INTO t3 VALUES('2008-02-29');
83 SELECT DAYNAME(c1) FROM t3;
84 DAYNAME(c1)
85 NULL
86 Friday
87 Saturday
88 Monday
89 Friday
90 DROP TABLE t3;
91 CREATE TABLE t3(c1 DATE NOT NULL);
92 INSERT INTO t3 VALUES('1000-01-01');
93 INSERT INTO t3 VALUES('1999-12-31');
94 INSERT INTO t3 VALUES('2000-01-01');
95 INSERT INTO t3 VALUES('2006-12-25');
96 INSERT INTO t3 VALUES('2008-02-29');
97 SELECT DAYOFMONTH(c1) FROM t3;
98 DAYOFMONTH(c1)
99 1
100 31
101 1
102 25
103 29
104 DROP TABLE t3;
105 CREATE TABLE t3(c1 DATETIME NOT NULL);
106 INSERT INTO t3 VALUES('1000-01-01');
107 INSERT INTO t3 VALUES('1999-12-31');
108 INSERT INTO t3 VALUES('2000-01-01');
109 INSERT INTO t3 VALUES('2006-12-25');
110 INSERT INTO t3 VALUES('2008-02-29');
111 SELECT DAYOFMONTH(c1) FROM t3;
112 DAYOFMONTH(c1)
113 1
114 31
115 1
116 25
117 29
118 DROP TABLE t3;
119 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
120 INSERT INTO t3 VALUES('1000-01-01');
121 Warnings:
122 Warning 1264 Out of range value for column 'c1' at row 1
123 INSERT INTO t3 VALUES('1999-12-31');
124 INSERT INTO t3 VALUES('2000-01-01');
125 INSERT INTO t3 VALUES('2006-12-25');
126 INSERT INTO t3 VALUES('2008-02-29');
127 SELECT DAYOFMONTH(c1) FROM t3;
128 DAYOFMONTH(c1)
129 0
130 31
131 1
132 25
133 29
134 DROP TABLE t3;
135 CREATE TABLE t3(c1 DATE NOT NULL);
136 INSERT INTO t3 VALUES('1000-01-01');
137 INSERT INTO t3 VALUES('1999-12-31');
138 INSERT INTO t3 VALUES('2000-01-01');
139 INSERT INTO t3 VALUES('2006-12-25');
140 INSERT INTO t3 VALUES('2008-02-29');
141 SELECT DAYOFWEEK(c1) FROM t3;
142 DAYOFWEEK(c1)
143 4
144 6
145 7
146 2
147 6
148 DROP TABLE t3;
149 CREATE TABLE t3(c1 DATETIME NOT NULL);
150 INSERT INTO t3 VALUES('1000-01-01');
151 INSERT INTO t3 VALUES('1999-12-31');
152 INSERT INTO t3 VALUES('2000-01-01');
153 INSERT INTO t3 VALUES('2006-12-25');
154 INSERT INTO t3 VALUES('2008-02-29');
155 SELECT DAYOFWEEK(c1) FROM t3;
156 DAYOFWEEK(c1)
157 4
158 6
159 7
160 2
161 6
162 DROP TABLE t3;
163 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
164 INSERT INTO t3 VALUES('1000-01-01');
165 Warnings:
166 Warning 1264 Out of range value for column 'c1' at row 1
167 INSERT INTO t3 VALUES('1999-12-31');
168 INSERT INTO t3 VALUES('2000-01-01');
169 INSERT INTO t3 VALUES('2006-12-25');
170 INSERT INTO t3 VALUES('2008-02-29');
171 SELECT DAYOFWEEK(c1) FROM t3;
172 DAYOFWEEK(c1)
173 NULL
174 6
175 7
176 2
177 6
178 DROP TABLE t3;
179 CREATE TABLE t3(c1 DATE NOT NULL);
180 INSERT INTO t3 VALUES('1000-01-01');
181 INSERT INTO t3 VALUES('1999-12-31');
182 INSERT INTO t3 VALUES('2000-01-01');
183 INSERT INTO t3 VALUES('2006-12-25');
184 INSERT INTO t3 VALUES('2008-02-29');
185 SELECT DAYOFYEAR(c1) FROM t3;
186 DAYOFYEAR(c1)
187 1
188 365
189 1
190 359
191 60
192 DROP TABLE t3;
193 CREATE TABLE t3(c1 DATETIME NOT NULL);
194 INSERT INTO t3 VALUES('1000-01-01');
195 INSERT INTO t3 VALUES('1999-12-31');
196 INSERT INTO t3 VALUES('2000-01-01');
197 INSERT INTO t3 VALUES('2006-12-25');
198 INSERT INTO t3 VALUES('2008-02-29');
199 SELECT DAYOFYEAR(c1) FROM t3;
200 DAYOFYEAR(c1)
201 1
202 365
203 1
204 359
205 60
206 DROP TABLE t3;
207 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
208 INSERT INTO t3 VALUES('1000-01-01');
209 Warnings:
210 Warning 1264 Out of range value for column 'c1' at row 1
211 INSERT INTO t3 VALUES('1999-12-31');
212 INSERT INTO t3 VALUES('2000-01-01');
213 INSERT INTO t3 VALUES('2006-12-25');
214 INSERT INTO t3 VALUES('2008-02-29');
215 SELECT DAYOFYEAR(c1) FROM t3;
216 DAYOFYEAR(c1)
217 NULL
218 365
219 1
220 359
221 60
222 DROP TABLE t3;
223 CREATE TABLE t3(c1 DATE NOT NULL);
224 INSERT INTO t3 VALUES('1000-01-01');
225 INSERT INTO t3 VALUES('1999-12-31');
226 INSERT INTO t3 VALUES('2000-01-01');
227 INSERT INTO t3 VALUES('2006-12-25');
228 INSERT INTO t3 VALUES('2008-02-29');
229 SELECT FROM_DAYS(c1) FROM t3;
230 FROM_DAYS(c1)
231 0000-00-00
232 0000-00-00
233 0000-00-00
234 0000-00-00
235 0000-00-00
236 DROP TABLE t3;
237 CREATE TABLE t3(c1 DATETIME NOT NULL);
238 INSERT INTO t3 VALUES('1000-01-01');
239 INSERT INTO t3 VALUES('1999-12-31');
240 INSERT INTO t3 VALUES('2000-01-01');
241 INSERT INTO t3 VALUES('2006-12-25');
242 INSERT INTO t3 VALUES('2008-02-29');
243 SELECT FROM_DAYS(c1) FROM t3;
244 FROM_DAYS(c1)
245 0000-00-00
246 0000-00-00
247 0000-00-00
248 0000-00-00
249 0000-00-00
250 DROP TABLE t3;
251 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
252 INSERT INTO t3 VALUES('1000-01-01');
253 Warnings:
254 Warning 1264 Out of range value for column 'c1' at row 1
255 INSERT INTO t3 VALUES('1999-12-31');
256 INSERT INTO t3 VALUES('2000-01-01');
257 INSERT INTO t3 VALUES('2006-12-25');
258 INSERT INTO t3 VALUES('2008-02-29');
259 SELECT FROM_DAYS(c1) FROM t3;
260 FROM_DAYS(c1)
261 0000-00-00
262 0000-00-00
263 0000-00-00
264 0000-00-00
265 0000-00-00
266 DROP TABLE t3;
267 CREATE TABLE t3(c1 DATE NOT NULL);
268 INSERT INTO t3 VALUES('1000-01-01');
269 INSERT INTO t3 VALUES('1999-12-31');
270 INSERT INTO t3 VALUES('2000-01-01');
271 INSERT INTO t3 VALUES('2006-12-25');
272 INSERT INTO t3 VALUES('2008-02-29');
273 SELECT LAST_DAY(c1) FROM t3;
274 LAST_DAY(c1)
275 1000-01-31
276 1999-12-31
277 2000-01-31
278 2006-12-31
279 2008-02-29
280 DROP TABLE t3;
281 CREATE TABLE t3(c1 DATETIME NOT NULL);
282 INSERT INTO t3 VALUES('1000-01-01');
283 INSERT INTO t3 VALUES('1999-12-31');
284 INSERT INTO t3 VALUES('2000-01-01');
285 INSERT INTO t3 VALUES('2006-12-25');
286 INSERT INTO t3 VALUES('2008-02-29');
287 SELECT LAST_DAY(c1) FROM t3;
288 LAST_DAY(c1)
289 1000-01-31
290 1999-12-31
291 2000-01-31
292 2006-12-31
293 2008-02-29
294 DROP TABLE t3;
295 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
296 INSERT INTO t3 VALUES('1000-01-01');
297 Warnings:
298 Warning 1264 Out of range value for column 'c1' at row 1
299 INSERT INTO t3 VALUES('1999-12-31');
300 INSERT INTO t3 VALUES('2000-01-01');
301 INSERT INTO t3 VALUES('2006-12-25');
302 INSERT INTO t3 VALUES('2008-02-29');
303 SELECT LAST_DAY(c1) FROM t3;
304 LAST_DAY(c1)
305 NULL
306 1999-12-31
307 2000-01-31
308 2006-12-31
309 2008-02-29
310 Warnings:
311 Warning 1292 Incorrect datetime value: '0000-00-00'
312 DROP TABLE t3;
313 CREATE TABLE t3(c1 DATE NOT NULL);
314 INSERT INTO t3 VALUES('1000-01-01');
315 INSERT INTO t3 VALUES('1999-12-31');
316 INSERT INTO t3 VALUES('2000-01-01');
317 INSERT INTO t3 VALUES('2006-12-25');
318 INSERT INTO t3 VALUES('2008-02-29');
319 SELECT MONTH(c1) FROM t3;
320 MONTH(c1)
321 1
322 12
323 1
324 12
325 2
326 DROP TABLE t3;
327 CREATE TABLE t3(c1 DATETIME NOT NULL);
328 INSERT INTO t3 VALUES('1000-01-01');
329 INSERT INTO t3 VALUES('1999-12-31');
330 INSERT INTO t3 VALUES('2000-01-01');
331 INSERT INTO t3 VALUES('2006-12-25');
332 INSERT INTO t3 VALUES('2008-02-29');
333 SELECT MONTH(c1) FROM t3;
334 MONTH(c1)
335 1
336 12
337 1
338 12
339 2
340 DROP TABLE t3;
341 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
342 INSERT INTO t3 VALUES('1000-01-01');
343 Warnings:
344 Warning 1264 Out of range value for column 'c1' at row 1
345 INSERT INTO t3 VALUES('1999-12-31');
346 INSERT INTO t3 VALUES('2000-01-01');
347 INSERT INTO t3 VALUES('2006-12-25');
348 INSERT INTO t3 VALUES('2008-02-29');
349 SELECT MONTH(c1) FROM t3;
350 MONTH(c1)
351 0
352 12
353 1
354 12
355 2
356 DROP TABLE t3;
357 CREATE TABLE t3(c1 DATE NOT NULL);
358 INSERT INTO t3 VALUES('1000-01-01');
359 INSERT INTO t3 VALUES('1999-12-31');
360 INSERT INTO t3 VALUES('2000-01-01');
361 INSERT INTO t3 VALUES('2006-12-25');
362 INSERT INTO t3 VALUES('2008-02-29');
363 SELECT MONTHNAME(c1) FROM t3;
364 MONTHNAME(c1)
365 January
366 December
367 January
368 December
369 February
370 DROP TABLE t3;
371 CREATE TABLE t3(c1 DATETIME NOT NULL);
372 INSERT INTO t3 VALUES('1000-01-01');
373 INSERT INTO t3 VALUES('1999-12-31');
374 INSERT INTO t3 VALUES('2000-01-01');
375 INSERT INTO t3 VALUES('2006-12-25');
376 INSERT INTO t3 VALUES('2008-02-29');
377 SELECT MONTHNAME(c1) FROM t3;
378 MONTHNAME(c1)
379 January
380 December
381 January
382 December
383 February
384 DROP TABLE t3;
385 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
386 INSERT INTO t3 VALUES('1000-01-01');
387 Warnings:
388 Warning 1264 Out of range value for column 'c1' at row 1
389 INSERT INTO t3 VALUES('1999-12-31');
390 INSERT INTO t3 VALUES('2000-01-01');
391 INSERT INTO t3 VALUES('2006-12-25');
392 INSERT INTO t3 VALUES('2008-02-29');
393 SELECT MONTHNAME(c1) FROM t3;
394 MONTHNAME(c1)
395 NULL
396 December
397 January
398 December
399 February
400 DROP TABLE t3;
401 CREATE TABLE t3(c1 DATE NOT NULL);
402 INSERT INTO t3 VALUES('1000-01-01');
403 INSERT INTO t3 VALUES('1999-12-31');
404 INSERT INTO t3 VALUES('2000-01-01');
405 INSERT INTO t3 VALUES('2006-12-25');
406 INSERT INTO t3 VALUES('2008-02-29');
407 SELECT QUARTER(c1) FROM t3;
408 QUARTER(c1)
409 1
410 4
411 1
412 4
413 1
414 DROP TABLE t3;
415 CREATE TABLE t3(c1 DATETIME NOT NULL);
416 INSERT INTO t3 VALUES('1000-01-01');
417 INSERT INTO t3 VALUES('1999-12-31');
418 INSERT INTO t3 VALUES('2000-01-01');
419 INSERT INTO t3 VALUES('2006-12-25');
420 INSERT INTO t3 VALUES('2008-02-29');
421 SELECT QUARTER(c1) FROM t3;
422 QUARTER(c1)
423 1
424 4
425 1
426 4
427 1
428 DROP TABLE t3;
429 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
430 INSERT INTO t3 VALUES('1000-01-01');
431 Warnings:
432 Warning 1264 Out of range value for column 'c1' at row 1
433 INSERT INTO t3 VALUES('1999-12-31');
434 INSERT INTO t3 VALUES('2000-01-01');
435 INSERT INTO t3 VALUES('2006-12-25');
436 INSERT INTO t3 VALUES('2008-02-29');
437 SELECT QUARTER(c1) FROM t3;
438 QUARTER(c1)
439 0
440 4
441 1
442 4
443 1
444 DROP TABLE t3;
445 CREATE TABLE t3(c1 DATE NOT NULL);
446 INSERT INTO t3 VALUES('1000-01-01');
447 INSERT INTO t3 VALUES('1999-12-31');
448 INSERT INTO t3 VALUES('2000-01-01');
449 INSERT INTO t3 VALUES('2006-12-25');
450 INSERT INTO t3 VALUES('2008-02-29');
451 SELECT TIMESTAMP(c1) FROM t3;
452 TIMESTAMP(c1)
453 1000-01-01 00:00:00
454 1999-12-31 00:00:00
455 2000-01-01 00:00:00
456 2006-12-25 00:00:00
457 2008-02-29 00:00:00
458 DROP TABLE t3;
459 CREATE TABLE t3(c1 DATETIME NOT NULL);
460 INSERT INTO t3 VALUES('1000-01-01');
461 INSERT INTO t3 VALUES('1999-12-31');
462 INSERT INTO t3 VALUES('2000-01-01');
463 INSERT INTO t3 VALUES('2006-12-25');
464 INSERT INTO t3 VALUES('2008-02-29');
465 SELECT TIMESTAMP(c1) FROM t3;
466 TIMESTAMP(c1)
467 1000-01-01 00:00:00
468 1999-12-31 00:00:00
469 2000-01-01 00:00:00
470 2006-12-25 00:00:00
471 2008-02-29 00:00:00
472 DROP TABLE t3;
473 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
474 INSERT INTO t3 VALUES('1000-01-01');
475 Warnings:
476 Warning 1264 Out of range value for column 'c1' at row 1
477 INSERT INTO t3 VALUES('1999-12-31');
478 INSERT INTO t3 VALUES('2000-01-01');
479 INSERT INTO t3 VALUES('2006-12-25');
480 INSERT INTO t3 VALUES('2008-02-29');
481 SELECT TIMESTAMP(c1) FROM t3;
482 TIMESTAMP(c1)
483 0000-00-00 00:00:00
484 1999-12-31 00:00:00
485 2000-01-01 00:00:00
486 2006-12-25 00:00:00
487 2008-02-29 00:00:00
488 DROP TABLE t3;
489 CREATE TABLE t3(c1 DATE NOT NULL);
490 INSERT INTO t3 VALUES('1000-01-01');
491 INSERT INTO t3 VALUES('1999-12-31');
492 INSERT INTO t3 VALUES('2000-01-01');
493 INSERT INTO t3 VALUES('2006-12-25');
494 INSERT INTO t3 VALUES('2008-02-29');
495 SELECT TO_DAYS(c1) FROM t3;
496 TO_DAYS(c1)
497 365243
498 730484
499 730485
500 733035
501 733466
502 DROP TABLE t3;
503 CREATE TABLE t3(c1 DATETIME NOT NULL);
504 INSERT INTO t3 VALUES('1000-01-01');
505 INSERT INTO t3 VALUES('1999-12-31');
506 INSERT INTO t3 VALUES('2000-01-01');
507 INSERT INTO t3 VALUES('2006-12-25');
508 INSERT INTO t3 VALUES('2008-02-29');
509 SELECT TO_DAYS(c1) FROM t3;
510 TO_DAYS(c1)
511 365243
512 730484
513 730485
514 733035
515 733466
516 DROP TABLE t3;
517 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
518 INSERT INTO t3 VALUES('1000-01-01');
519 Warnings:
520 Warning 1264 Out of range value for column 'c1' at row 1
521 INSERT INTO t3 VALUES('1999-12-31');
522 INSERT INTO t3 VALUES('2000-01-01');
523 INSERT INTO t3 VALUES('2006-12-25');
524 INSERT INTO t3 VALUES('2008-02-29');
525 SELECT TO_DAYS(c1) FROM t3;
526 TO_DAYS(c1)
527 NULL
528 730484
529 730485
530 733035
531 733466
532 DROP TABLE t3;
533 CREATE TABLE t3(c1 DATE NOT NULL);
534 INSERT INTO t3 VALUES('1000-01-01');
535 INSERT INTO t3 VALUES('1999-12-31');
536 INSERT INTO t3 VALUES('2000-01-01');
537 INSERT INTO t3 VALUES('2006-12-25');
538 INSERT INTO t3 VALUES('2008-02-29');
539 SELECT WEEK(c1) FROM t3;
540 WEEK(c1)
541 0
542 52
543 0
544 52
545 8
546 DROP TABLE t3;
547 CREATE TABLE t3(c1 DATETIME NOT NULL);
548 INSERT INTO t3 VALUES('1000-01-01');
549 INSERT INTO t3 VALUES('1999-12-31');
550 INSERT INTO t3 VALUES('2000-01-01');
551 INSERT INTO t3 VALUES('2006-12-25');
552 INSERT INTO t3 VALUES('2008-02-29');
553 SELECT WEEK(c1) FROM t3;
554 WEEK(c1)
555 0
556 52
557 0
558 52
559 8
560 DROP TABLE t3;
561 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
562 INSERT INTO t3 VALUES('1000-01-01');
563 Warnings:
564 Warning 1264 Out of range value for column 'c1' at row 1
565 INSERT INTO t3 VALUES('1999-12-31');
566 INSERT INTO t3 VALUES('2000-01-01');
567 INSERT INTO t3 VALUES('2006-12-25');
568 INSERT INTO t3 VALUES('2008-02-29');
569 SELECT WEEK(c1) FROM t3;
570 WEEK(c1)
571 NULL
572 52
573 0
574 52
575 8
576 DROP TABLE t3;
577 CREATE TABLE t3(c1 DATE NOT NULL);
578 INSERT INTO t3 VALUES('1000-01-01');
579 INSERT INTO t3 VALUES('1999-12-31');
580 INSERT INTO t3 VALUES('2000-01-01');
581 INSERT INTO t3 VALUES('2006-12-25');
582 INSERT INTO t3 VALUES('2008-02-29');
583 SELECT WEEKDAY(c1) FROM t3;
584 WEEKDAY(c1)
585 2
586 4
587 5
588 0
589 4
590 DROP TABLE t3;
591 CREATE TABLE t3(c1 DATETIME NOT NULL);
592 INSERT INTO t3 VALUES('1000-01-01');
593 INSERT INTO t3 VALUES('1999-12-31');
594 INSERT INTO t3 VALUES('2000-01-01');
595 INSERT INTO t3 VALUES('2006-12-25');
596 INSERT INTO t3 VALUES('2008-02-29');
597 SELECT WEEKDAY(c1) FROM t3;
598 WEEKDAY(c1)
599 2
600 4
601 5
602 0
603 4
604 DROP TABLE t3;
605 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
606 INSERT INTO t3 VALUES('1000-01-01');
607 Warnings:
608 Warning 1264 Out of range value for column 'c1' at row 1
609 INSERT INTO t3 VALUES('1999-12-31');
610 INSERT INTO t3 VALUES('2000-01-01');
611 INSERT INTO t3 VALUES('2006-12-25');
612 INSERT INTO t3 VALUES('2008-02-29');
613 SELECT WEEKDAY(c1) FROM t3;
614 WEEKDAY(c1)
615 NULL
616 4
617 5
618 0
619 4
620 DROP TABLE t3;
621 CREATE TABLE t3(c1 DATE NOT NULL);
622 INSERT INTO t3 VALUES('1000-01-01');
623 INSERT INTO t3 VALUES('1999-12-31');
624 INSERT INTO t3 VALUES('2000-01-01');
625 INSERT INTO t3 VALUES('2006-12-25');
626 INSERT INTO t3 VALUES('2008-02-29');
627 SELECT WEEKOFYEAR(c1) FROM t3;
628 WEEKOFYEAR(c1)
629 1
630 52
631 52
632 52
633 9
634 DROP TABLE t3;
635 CREATE TABLE t3(c1 DATETIME NOT NULL);
636 INSERT INTO t3 VALUES('1000-01-01');
637 INSERT INTO t3 VALUES('1999-12-31');
638 INSERT INTO t3 VALUES('2000-01-01');
639 INSERT INTO t3 VALUES('2006-12-25');
640 INSERT INTO t3 VALUES('2008-02-29');
641 SELECT WEEKOFYEAR(c1) FROM t3;
642 WEEKOFYEAR(c1)
643 1
644 52
645 52
646 52
647 9
648 DROP TABLE t3;
649 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
650 INSERT INTO t3 VALUES('1000-01-01');
651 Warnings:
652 Warning 1264 Out of range value for column 'c1' at row 1
653 INSERT INTO t3 VALUES('1999-12-31');
654 INSERT INTO t3 VALUES('2000-01-01');
655 INSERT INTO t3 VALUES('2006-12-25');
656 INSERT INTO t3 VALUES('2008-02-29');
657 SELECT WEEKOFYEAR(c1) FROM t3;
658 WEEKOFYEAR(c1)
659 NULL
660 52
661 52
662 52
663 9
664 DROP TABLE t3;
665 CREATE TABLE t3(c1 DATE NOT NULL);
666 INSERT INTO t3 VALUES('1000-01-01');
667 INSERT INTO t3 VALUES('1999-12-31');
668 INSERT INTO t3 VALUES('2000-01-01');
669 INSERT INTO t3 VALUES('2006-12-25');
670 INSERT INTO t3 VALUES('2008-02-29');
671 SELECT YEAR(c1) FROM t3;
672 YEAR(c1)
673 1000
674 1999
675 2000
676 2006
677 2008
678 DROP TABLE t3;
679 CREATE TABLE t3(c1 DATETIME NOT NULL);
680 INSERT INTO t3 VALUES('1000-01-01');
681 INSERT INTO t3 VALUES('1999-12-31');
682 INSERT INTO t3 VALUES('2000-01-01');
683 INSERT INTO t3 VALUES('2006-12-25');
684 INSERT INTO t3 VALUES('2008-02-29');
685 SELECT YEAR(c1) FROM t3;
686 YEAR(c1)
687 1000
688 1999
689 2000
690 2006
691 2008
692 DROP TABLE t3;
693 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
694 INSERT INTO t3 VALUES('1000-01-01');
695 Warnings:
696 Warning 1264 Out of range value for column 'c1' at row 1
697 INSERT INTO t3 VALUES('1999-12-31');
698 INSERT INTO t3 VALUES('2000-01-01');
699 INSERT INTO t3 VALUES('2006-12-25');
700 INSERT INTO t3 VALUES('2008-02-29');
701 SELECT YEAR(c1) FROM t3;
702 YEAR(c1)
703 0
704 1999
705 2000
706 2006
707 2008
708 DROP TABLE t3;
709 CREATE TABLE t3(c1 DATE NOT NULL);
710 INSERT INTO t3 VALUES('1000-01-01');
711 INSERT INTO t3 VALUES('1999-12-31');
712 INSERT INTO t3 VALUES('2000-01-01');
713 INSERT INTO t3 VALUES('2006-12-25');
714 INSERT INTO t3 VALUES('2008-02-29');
715 SELECT YEARWEEK(c1) FROM t3;
716 YEARWEEK(c1)
717 99952
718 199952
719 199952
720 200652
721 200808
722 DROP TABLE t3;
723 CREATE TABLE t3(c1 DATETIME NOT NULL);
724 INSERT INTO t3 VALUES('1000-01-01');
725 INSERT INTO t3 VALUES('1999-12-31');
726 INSERT INTO t3 VALUES('2000-01-01');
727 INSERT INTO t3 VALUES('2006-12-25');
728 INSERT INTO t3 VALUES('2008-02-29');
729 SELECT YEARWEEK(c1) FROM t3;
730 YEARWEEK(c1)
731 99952
732 199952
733 199952
734 200652
735 200808
736 DROP TABLE t3;
737 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
738 INSERT INTO t3 VALUES('1000-01-01');
739 Warnings:
740 Warning 1264 Out of range value for column 'c1' at row 1
741 INSERT INTO t3 VALUES('1999-12-31');
742 INSERT INTO t3 VALUES('2000-01-01');
743 INSERT INTO t3 VALUES('2006-12-25');
744 INSERT INTO t3 VALUES('2008-02-29');
745 SELECT YEARWEEK(c1) FROM t3;
746 YEARWEEK(c1)
747 NULL
748 199952
749 199952
750 200652
751 200808
752 DROP TABLE t3;
753 SET sql_mode=default;