5
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near ')' at line 1
7
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near ' 0)' at line 1
9
ERROR HY000: Received an invalid datetime value 'xxx'.
10
SELECT MONTH("0000-00-00");
11
ERROR HY000: Received an invalid datetime value '0000-00-00'.
12
SELECT MONTH("0000-01-01");
13
ERROR HY000: Received an invalid datetime value '0000-01-01'.
14
SELECT MONTH("0001-00-01");
15
ERROR HY000: Received an invalid datetime value '0001-00-01'.
16
SELECT MONTH("0001-01-00");
17
ERROR HY000: Received an invalid datetime value '0001-01-00'.
18
SELECT MONTH("2000-02-30");
19
ERROR HY000: Received an invalid datetime value '2000-02-30'.
20
SELECT MONTH("1900-02-29");
21
ERROR HY000: Received an invalid datetime value '1900-02-29'.
22
SELECT MONTH('1976-15-15');
23
ERROR HY000: Received an invalid datetime value '1976-15-15'.
24
SELECT MONTH("2009-01-12");
27
SELECT MONTH("99-1-31");
30
SELECT MONTH("0001-09-30");
33
SELECT MONTH("9999-12-31");
36
SELECT MONTH('07/31/2009');
39
SELECT MONTH('20090916');
42
SELECT MONTH('20090916091528');
43
MONTH('20090916091528')
45
SELECT MONTH("20090916091528.000000");
46
MONTH("20090916091528.000000")
48
SELECT MONTH('09-09-16');
51
SELECT MONTH('09.09.16');
54
SELECT MONTH('09/09/16');
57
SELECT MONTH('09-09-16');
60
SELECT MONTH('09-9-2');
63
SELECT MONTH(20090916);
66
SELECT MONTH(20090916091528);
69
SELECT MONTH(20090916091528.000000);
70
ERROR HY000: Received an invalid datetime value '20090916091528.000000'.
72
DROP TABLE IF EXISTS t1;
75
, date_fld DATE NOT NULL
76
, datetime_fld DATETIME NOT NULL
77
, timestamp_fld TIMESTAMP NOT NULL
78
, char_fld CHAR(22) NOT NULL
79
, varchar_fld VARCHAR(22) NOT NULL
80
, text_fld TEXT NOT NULL
81
, blob_fld BLOB NOT NULL
83
INSERT INTO t1 VALUES (
86
, "2007-11-30 16:30:19"
87
, "2007-11-30T16:30:19"
88
, "2007-11-30 16:30:19"
89
, "2007-11-30 16:30:19"
90
, "2007-11-30T16:30:19"
91
, "2007-11-30T16:30:19"
93
SELECT MONTH(int_fld) FROM t1;
96
SELECT MONTH(date_fld) FROM t1;
99
SELECT MONTH(datetime_fld) FROM t1;
102
SELECT MONTH(timestamp_fld) FROM t1;
105
SELECT MONTH(char_fld) FROM t1;
108
SELECT MONTH(varchar_fld) FROM t1;
111
SELECT MONTH(text_fld) FROM t1;
114
SELECT MONTH(blob_fld) FROM t1;