mysql-test/main/func_extract.test

7   EXTRACT(DAY FROM t),
12   EXTRACT(DAY FROM d),
17   EXTRACT(DAY FROM v),
22   EXTRACT(DAY FROM ll),
58 SELECT a, b, EXTRACT(DAY FROM a), EXTRACT(DAY FROM b) FROM t1 WHERE NOT (EXTRACT(DAY FROM a)<=>EXTR…
69   EXTRACT(DAY FROM a) * 24 + EXTRACT(HOUR FROM a) AS dh,
71   EXTRACT(DAY FROM a),
80   EXTRACT(DAY FROM b) * 24 + EXTRACT(HOUR FROM b) AS dh,
82   EXTRACT(DAY FROM b),
90 --echo # Special case: DAY + TIME
98   EXTRACT(DAY FROM a),
115   EXTRACT(DAY FROM a),
129 SELECT EXTRACT(DAY   FROM '2001/02/03 10:20:30');
133 SELECT EXTRACT(DAY   FROM '01/02/03 10:20:30');
137 SELECT EXTRACT(DAY   FROM '01:02:03 10:20:30');
143 SELECT EXTRACT(DAY   FROM "2011-02-32 8:46:06.23434");
150 SELECT EXTRACT(DAY   FROM '2001/02/03');
154 SELECT EXTRACT(DAY   FROM '01/02/03');
158 SELECT EXTRACT(DAY   FROM '01-02-03');
162 SELECT EXTRACT(DAY   FROM '1-2-3');
165 SELECT EXTRACT(DAY FROM '2024-01-03 garbage /////');
166 SELECT EXTRACT(DAY FROM '24-01-03 garbage /////');
167 SELECT EXTRACT(DAY FROM '01-02-03');
169 SELECT EXTRACT(DAY FROM '24:02:03T');
170 SELECT EXTRACT(DAY FROM '24-02-03');
171 SELECT EXTRACT(DAY FROM '24/02/03');
173 SELECT EXTRACT(DAY FROM '11111');
179 SELECT EXTRACT(DAY FROM '2001-01-01T'), EXTRACT(DAY FROM '2001-01-01T ');
180 SELECT EXTRACT(DAY FROM '2001/01/01T'), EXTRACT(DAY FROM '2001/01/01T ');
181 SELECT EXTRACT(DAY FROM '2001:01:01T'), EXTRACT(DAY FROM '2001:01:01T ');
190 SELECT EXTRACT(DAY FROM '100000:02:03T');
191 SELECT EXTRACT(DAY FROM '100000/02/03');
192 SELECT EXTRACT(DAY FROM '100000-02-03');
194 SELECT EXTRACT(DAY FROM '1111');
195 SELECT EXTRACT(DAY FROM '111');
196 SELECT EXTRACT(DAY FROM '11');
197 SELECT EXTRACT(DAY FROM '1');
219 --echo # (behavior has changed for DAY, see below)
253   EXTRACT(DAY FROM a),