Debian Codegraph @

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

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