mirror of
https://github.com/MariaDB/server.git
synced 2025-10-30 18:36:12 +01:00
749 lines
17 KiB
Text
749 lines
17 KiB
Text
DROP TABLE IF EXISTS t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DATE(c1) FROM t3;
|
|
DATE(c1)
|
|
1000-01-01
|
|
1999-12-31
|
|
2000-01-01
|
|
2006-12-25
|
|
2008-02-29
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DATE(c1) FROM t3;
|
|
DATE(c1)
|
|
1000-01-01
|
|
1999-12-31
|
|
2000-01-01
|
|
2006-12-25
|
|
2008-02-29
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DATE(c1) FROM t3;
|
|
DATE(c1)
|
|
0000-00-00
|
|
1999-12-31
|
|
2000-01-01
|
|
2006-12-25
|
|
2008-02-29
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYNAME(c1) FROM t3;
|
|
DAYNAME(c1)
|
|
Wednesday
|
|
Friday
|
|
Saturday
|
|
Monday
|
|
Friday
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYNAME(c1) FROM t3;
|
|
DAYNAME(c1)
|
|
Wednesday
|
|
Friday
|
|
Saturday
|
|
Monday
|
|
Friday
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYNAME(c1) FROM t3;
|
|
DAYNAME(c1)
|
|
NULL
|
|
Friday
|
|
Saturday
|
|
Monday
|
|
Friday
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYOFMONTH(c1) FROM t3;
|
|
DAYOFMONTH(c1)
|
|
1
|
|
31
|
|
1
|
|
25
|
|
29
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYOFMONTH(c1) FROM t3;
|
|
DAYOFMONTH(c1)
|
|
1
|
|
31
|
|
1
|
|
25
|
|
29
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYOFMONTH(c1) FROM t3;
|
|
DAYOFMONTH(c1)
|
|
0
|
|
31
|
|
1
|
|
25
|
|
29
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYOFWEEK(c1) FROM t3;
|
|
DAYOFWEEK(c1)
|
|
4
|
|
6
|
|
7
|
|
2
|
|
6
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYOFWEEK(c1) FROM t3;
|
|
DAYOFWEEK(c1)
|
|
4
|
|
6
|
|
7
|
|
2
|
|
6
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYOFWEEK(c1) FROM t3;
|
|
DAYOFWEEK(c1)
|
|
NULL
|
|
6
|
|
7
|
|
2
|
|
6
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYOFYEAR(c1) FROM t3;
|
|
DAYOFYEAR(c1)
|
|
1
|
|
365
|
|
1
|
|
359
|
|
60
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYOFYEAR(c1) FROM t3;
|
|
DAYOFYEAR(c1)
|
|
1
|
|
365
|
|
1
|
|
359
|
|
60
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT DAYOFYEAR(c1) FROM t3;
|
|
DAYOFYEAR(c1)
|
|
NULL
|
|
365
|
|
1
|
|
359
|
|
60
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT FROM_DAYS(c1) FROM t3;
|
|
FROM_DAYS(c1)
|
|
0000-00-00
|
|
0000-00-00
|
|
0000-00-00
|
|
0000-00-00
|
|
0000-00-00
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT FROM_DAYS(c1) FROM t3;
|
|
FROM_DAYS(c1)
|
|
0000-00-00
|
|
0000-00-00
|
|
0000-00-00
|
|
0000-00-00
|
|
0000-00-00
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT FROM_DAYS(c1) FROM t3;
|
|
FROM_DAYS(c1)
|
|
0000-00-00
|
|
0000-00-00
|
|
0000-00-00
|
|
0000-00-00
|
|
0000-00-00
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT LAST_DAY(c1) FROM t3;
|
|
LAST_DAY(c1)
|
|
1000-01-31
|
|
1999-12-31
|
|
2000-01-31
|
|
2006-12-31
|
|
2008-02-29
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT LAST_DAY(c1) FROM t3;
|
|
LAST_DAY(c1)
|
|
1000-01-31
|
|
1999-12-31
|
|
2000-01-31
|
|
2006-12-31
|
|
2008-02-29
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT LAST_DAY(c1) FROM t3;
|
|
LAST_DAY(c1)
|
|
NULL
|
|
1999-12-31
|
|
2000-01-31
|
|
2006-12-31
|
|
2008-02-29
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT MONTH(c1) FROM t3;
|
|
MONTH(c1)
|
|
1
|
|
12
|
|
1
|
|
12
|
|
2
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT MONTH(c1) FROM t3;
|
|
MONTH(c1)
|
|
1
|
|
12
|
|
1
|
|
12
|
|
2
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT MONTH(c1) FROM t3;
|
|
MONTH(c1)
|
|
0
|
|
12
|
|
1
|
|
12
|
|
2
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT MONTHNAME(c1) FROM t3;
|
|
MONTHNAME(c1)
|
|
January
|
|
December
|
|
January
|
|
December
|
|
February
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT MONTHNAME(c1) FROM t3;
|
|
MONTHNAME(c1)
|
|
January
|
|
December
|
|
January
|
|
December
|
|
February
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT MONTHNAME(c1) FROM t3;
|
|
MONTHNAME(c1)
|
|
NULL
|
|
December
|
|
January
|
|
December
|
|
February
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT QUARTER(c1) FROM t3;
|
|
QUARTER(c1)
|
|
1
|
|
4
|
|
1
|
|
4
|
|
1
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT QUARTER(c1) FROM t3;
|
|
QUARTER(c1)
|
|
1
|
|
4
|
|
1
|
|
4
|
|
1
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT QUARTER(c1) FROM t3;
|
|
QUARTER(c1)
|
|
0
|
|
4
|
|
1
|
|
4
|
|
1
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT TIMESTAMP(c1) FROM t3;
|
|
TIMESTAMP(c1)
|
|
1000-01-01 00:00:00
|
|
1999-12-31 00:00:00
|
|
2000-01-01 00:00:00
|
|
2006-12-25 00:00:00
|
|
2008-02-29 00:00:00
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT TIMESTAMP(c1) FROM t3;
|
|
TIMESTAMP(c1)
|
|
1000-01-01 00:00:00
|
|
1999-12-31 00:00:00
|
|
2000-01-01 00:00:00
|
|
2006-12-25 00:00:00
|
|
2008-02-29 00:00:00
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT TIMESTAMP(c1) FROM t3;
|
|
TIMESTAMP(c1)
|
|
0000-00-00 00:00:00
|
|
1999-12-31 00:00:00
|
|
2000-01-01 00:00:00
|
|
2006-12-25 00:00:00
|
|
2008-02-29 00:00:00
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT TO_DAYS(c1) FROM t3;
|
|
TO_DAYS(c1)
|
|
365243
|
|
730484
|
|
730485
|
|
733035
|
|
733466
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT TO_DAYS(c1) FROM t3;
|
|
TO_DAYS(c1)
|
|
365243
|
|
730484
|
|
730485
|
|
733035
|
|
733466
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT TO_DAYS(c1) FROM t3;
|
|
TO_DAYS(c1)
|
|
NULL
|
|
730484
|
|
730485
|
|
733035
|
|
733466
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT WEEK(c1) FROM t3;
|
|
WEEK(c1)
|
|
0
|
|
52
|
|
0
|
|
52
|
|
8
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT WEEK(c1) FROM t3;
|
|
WEEK(c1)
|
|
0
|
|
52
|
|
0
|
|
52
|
|
8
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT WEEK(c1) FROM t3;
|
|
WEEK(c1)
|
|
NULL
|
|
52
|
|
0
|
|
52
|
|
8
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT WEEKDAY(c1) FROM t3;
|
|
WEEKDAY(c1)
|
|
2
|
|
4
|
|
5
|
|
0
|
|
4
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT WEEKDAY(c1) FROM t3;
|
|
WEEKDAY(c1)
|
|
2
|
|
4
|
|
5
|
|
0
|
|
4
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT WEEKDAY(c1) FROM t3;
|
|
WEEKDAY(c1)
|
|
NULL
|
|
4
|
|
5
|
|
0
|
|
4
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT WEEKOFYEAR(c1) FROM t3;
|
|
WEEKOFYEAR(c1)
|
|
1
|
|
52
|
|
52
|
|
52
|
|
9
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT WEEKOFYEAR(c1) FROM t3;
|
|
WEEKOFYEAR(c1)
|
|
1
|
|
52
|
|
52
|
|
52
|
|
9
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT WEEKOFYEAR(c1) FROM t3;
|
|
WEEKOFYEAR(c1)
|
|
NULL
|
|
52
|
|
52
|
|
52
|
|
9
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT YEAR(c1) FROM t3;
|
|
YEAR(c1)
|
|
1000
|
|
1999
|
|
2000
|
|
2006
|
|
2008
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT YEAR(c1) FROM t3;
|
|
YEAR(c1)
|
|
1000
|
|
1999
|
|
2000
|
|
2006
|
|
2008
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT YEAR(c1) FROM t3;
|
|
YEAR(c1)
|
|
0
|
|
1999
|
|
2000
|
|
2006
|
|
2008
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATE NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT YEARWEEK(c1) FROM t3;
|
|
YEARWEEK(c1)
|
|
99952
|
|
199952
|
|
199952
|
|
200652
|
|
200808
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
INSERT INTO t3 VALUES('1000-01-01');
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT YEARWEEK(c1) FROM t3;
|
|
YEARWEEK(c1)
|
|
99952
|
|
199952
|
|
199952
|
|
200652
|
|
200808
|
|
DROP TABLE t3;
|
|
CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
|
|
INSERT IGNORE INTO t3 VALUES('1000-01-01');
|
|
Warnings:
|
|
Warning 1264 Out of range value for column 'c1' at row 1
|
|
INSERT INTO t3 VALUES('1999-12-31');
|
|
INSERT INTO t3 VALUES('2000-01-01');
|
|
INSERT INTO t3 VALUES('2006-12-25');
|
|
INSERT INTO t3 VALUES('2008-02-29');
|
|
SELECT YEARWEEK(c1) FROM t3;
|
|
YEARWEEK(c1)
|
|
NULL
|
|
199952
|
|
199952
|
|
200652
|
|
200808
|
|
DROP TABLE t3;
|