Debian Codegraph @

mysql-test/suite/engines/funcs/t/date_function.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t3;
3 --enable_warnings
4 SET sql_mode='NO_ENGINE_SUBSTITUTION';
5 CREATE TABLE t3(c1 DATE NOT NULL);
6 INSERT INTO t3 VALUES('1000-01-01');
7 INSERT INTO t3 VALUES('1999-12-31');
8 INSERT INTO t3 VALUES('2000-01-01');
9 INSERT INTO t3 VALUES('2006-12-25');
10 INSERT INTO t3 VALUES('2008-02-29');
11 SELECT DATE(c1) FROM t3;
12 DROP TABLE t3;
13 CREATE TABLE t3(c1 DATETIME NOT NULL);
14 INSERT INTO t3 VALUES('1000-01-01');
15 INSERT INTO t3 VALUES('1999-12-31');
16 INSERT INTO t3 VALUES('2000-01-01');
17 INSERT INTO t3 VALUES('2006-12-25');
18 INSERT INTO t3 VALUES('2008-02-29');
19 SELECT DATE(c1) FROM t3;
20 DROP TABLE t3;
21 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
22 INSERT INTO t3 VALUES('1000-01-01');
23 INSERT INTO t3 VALUES('1999-12-31');
24 INSERT INTO t3 VALUES('2000-01-01');
25 INSERT INTO t3 VALUES('2006-12-25');
26 INSERT INTO t3 VALUES('2008-02-29');
27 SELECT DATE(c1) FROM t3;
28 DROP TABLE t3;
29 CREATE TABLE t3(c1 DATE NOT NULL);
30 INSERT INTO t3 VALUES('1000-01-01');
31 INSERT INTO t3 VALUES('1999-12-31');
32 INSERT INTO t3 VALUES('2000-01-01');
33 INSERT INTO t3 VALUES('2006-12-25');
34 INSERT INTO t3 VALUES('2008-02-29');
35 SELECT DAYNAME(c1) FROM t3;
36 DROP TABLE t3;
37 CREATE TABLE t3(c1 DATETIME NOT NULL);
38 INSERT INTO t3 VALUES('1000-01-01');
39 INSERT INTO t3 VALUES('1999-12-31');
40 INSERT INTO t3 VALUES('2000-01-01');
41 INSERT INTO t3 VALUES('2006-12-25');
42 INSERT INTO t3 VALUES('2008-02-29');
43 SELECT DAYNAME(c1) FROM t3;
44 DROP TABLE t3;
45 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
46 INSERT INTO t3 VALUES('1000-01-01');
47 INSERT INTO t3 VALUES('1999-12-31');
48 INSERT INTO t3 VALUES('2000-01-01');
49 INSERT INTO t3 VALUES('2006-12-25');
50 INSERT INTO t3 VALUES('2008-02-29');
51 SELECT DAYNAME(c1) FROM t3;
52 DROP TABLE t3;
53 CREATE TABLE t3(c1 DATE NOT NULL);
54 INSERT INTO t3 VALUES('1000-01-01');
55 INSERT INTO t3 VALUES('1999-12-31');
56 INSERT INTO t3 VALUES('2000-01-01');
57 INSERT INTO t3 VALUES('2006-12-25');
58 INSERT INTO t3 VALUES('2008-02-29');
59 SELECT DAYOFMONTH(c1) FROM t3;
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 DAYOFMONTH(c1) FROM t3;
68 DROP TABLE t3;
69 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
70 INSERT INTO t3 VALUES('1000-01-01');
71 INSERT INTO t3 VALUES('1999-12-31');
72 INSERT INTO t3 VALUES('2000-01-01');
73 INSERT INTO t3 VALUES('2006-12-25');
74 INSERT INTO t3 VALUES('2008-02-29');
75 SELECT DAYOFMONTH(c1) FROM t3;
76 DROP TABLE t3;
77 CREATE TABLE t3(c1 DATE NOT NULL);
78 INSERT INTO t3 VALUES('1000-01-01');
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 DAYOFWEEK(c1) FROM t3;
84 DROP TABLE t3;
85 CREATE TABLE t3(c1 DATETIME NOT NULL);
86 INSERT INTO t3 VALUES('1000-01-01');
87 INSERT INTO t3 VALUES('1999-12-31');
88 INSERT INTO t3 VALUES('2000-01-01');
89 INSERT INTO t3 VALUES('2006-12-25');
90 INSERT INTO t3 VALUES('2008-02-29');
91 SELECT DAYOFWEEK(c1) FROM t3;
92 DROP TABLE t3;
93 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
94 INSERT INTO t3 VALUES('1000-01-01');
95 INSERT INTO t3 VALUES('1999-12-31');
96 INSERT INTO t3 VALUES('2000-01-01');
97 INSERT INTO t3 VALUES('2006-12-25');
98 INSERT INTO t3 VALUES('2008-02-29');
99 SELECT DAYOFWEEK(c1) FROM t3;
100 DROP TABLE t3;
101 CREATE TABLE t3(c1 DATE NOT NULL);
102 INSERT INTO t3 VALUES('1000-01-01');
103 INSERT INTO t3 VALUES('1999-12-31');
104 INSERT INTO t3 VALUES('2000-01-01');
105 INSERT INTO t3 VALUES('2006-12-25');
106 INSERT INTO t3 VALUES('2008-02-29');
107 SELECT DAYOFYEAR(c1) FROM t3;
108 DROP TABLE t3;
109 CREATE TABLE t3(c1 DATETIME NOT NULL);
110 INSERT INTO t3 VALUES('1000-01-01');
111 INSERT INTO t3 VALUES('1999-12-31');
112 INSERT INTO t3 VALUES('2000-01-01');
113 INSERT INTO t3 VALUES('2006-12-25');
114 INSERT INTO t3 VALUES('2008-02-29');
115 SELECT DAYOFYEAR(c1) FROM t3;
116 DROP TABLE t3;
117 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
118 INSERT INTO t3 VALUES('1000-01-01');
119 INSERT INTO t3 VALUES('1999-12-31');
120 INSERT INTO t3 VALUES('2000-01-01');
121 INSERT INTO t3 VALUES('2006-12-25');
122 INSERT INTO t3 VALUES('2008-02-29');
123 SELECT DAYOFYEAR(c1) FROM t3;
124 DROP TABLE t3;
125 CREATE TABLE t3(c1 DATE NOT NULL);
126 INSERT INTO t3 VALUES('1000-01-01');
127 INSERT INTO t3 VALUES('1999-12-31');
128 INSERT INTO t3 VALUES('2000-01-01');
129 INSERT INTO t3 VALUES('2006-12-25');
130 INSERT INTO t3 VALUES('2008-02-29');
131 SELECT FROM_DAYS(c1) FROM t3;
132 DROP TABLE t3;
133 CREATE TABLE t3(c1 DATETIME NOT NULL);
134 INSERT INTO t3 VALUES('1000-01-01');
135 INSERT INTO t3 VALUES('1999-12-31');
136 INSERT INTO t3 VALUES('2000-01-01');
137 INSERT INTO t3 VALUES('2006-12-25');
138 INSERT INTO t3 VALUES('2008-02-29');
139 SELECT FROM_DAYS(c1) FROM t3;
140 DROP TABLE t3;
141 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
142 INSERT INTO t3 VALUES('1000-01-01');
143 INSERT INTO t3 VALUES('1999-12-31');
144 INSERT INTO t3 VALUES('2000-01-01');
145 INSERT INTO t3 VALUES('2006-12-25');
146 INSERT INTO t3 VALUES('2008-02-29');
147 SELECT FROM_DAYS(c1) FROM t3;
148 DROP TABLE t3;
149 CREATE TABLE t3(c1 DATE 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 LAST_DAY(c1) FROM t3;
156 DROP TABLE t3;
157 CREATE TABLE t3(c1 DATETIME NOT NULL);
158 INSERT INTO t3 VALUES('1000-01-01');
159 INSERT INTO t3 VALUES('1999-12-31');
160 INSERT INTO t3 VALUES('2000-01-01');
161 INSERT INTO t3 VALUES('2006-12-25');
162 INSERT INTO t3 VALUES('2008-02-29');
163 SELECT LAST_DAY(c1) FROM t3;
164 DROP TABLE t3;
165 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
166 INSERT INTO t3 VALUES('1000-01-01');
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 LAST_DAY(c1) FROM t3;
172 DROP TABLE t3;
173 CREATE TABLE t3(c1 DATE NOT NULL);
174 INSERT INTO t3 VALUES('1000-01-01');
175 INSERT INTO t3 VALUES('1999-12-31');
176 INSERT INTO t3 VALUES('2000-01-01');
177 INSERT INTO t3 VALUES('2006-12-25');
178 INSERT INTO t3 VALUES('2008-02-29');
179 SELECT MONTH(c1) FROM t3;
180 DROP TABLE t3;
181 CREATE TABLE t3(c1 DATETIME NOT NULL);
182 INSERT INTO t3 VALUES('1000-01-01');
183 INSERT INTO t3 VALUES('1999-12-31');
184 INSERT INTO t3 VALUES('2000-01-01');
185 INSERT INTO t3 VALUES('2006-12-25');
186 INSERT INTO t3 VALUES('2008-02-29');
187 SELECT MONTH(c1) FROM t3;
188 DROP TABLE t3;
189 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
190 INSERT INTO t3 VALUES('1000-01-01');
191 INSERT INTO t3 VALUES('1999-12-31');
192 INSERT INTO t3 VALUES('2000-01-01');
193 INSERT INTO t3 VALUES('2006-12-25');
194 INSERT INTO t3 VALUES('2008-02-29');
195 SELECT MONTH(c1) FROM t3;
196 DROP TABLE t3;
197 CREATE TABLE t3(c1 DATE NOT NULL);
198 INSERT INTO t3 VALUES('1000-01-01');
199 INSERT INTO t3 VALUES('1999-12-31');
200 INSERT INTO t3 VALUES('2000-01-01');
201 INSERT INTO t3 VALUES('2006-12-25');
202 INSERT INTO t3 VALUES('2008-02-29');
203 SELECT MONTHNAME(c1) FROM t3;
204 DROP TABLE t3;
205 CREATE TABLE t3(c1 DATETIME NOT NULL);
206 INSERT INTO t3 VALUES('1000-01-01');
207 INSERT INTO t3 VALUES('1999-12-31');
208 INSERT INTO t3 VALUES('2000-01-01');
209 INSERT INTO t3 VALUES('2006-12-25');
210 INSERT INTO t3 VALUES('2008-02-29');
211 SELECT MONTHNAME(c1) FROM t3;
212 DROP TABLE t3;
213 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
214 INSERT INTO t3 VALUES('1000-01-01');
215 INSERT INTO t3 VALUES('1999-12-31');
216 INSERT INTO t3 VALUES('2000-01-01');
217 INSERT INTO t3 VALUES('2006-12-25');
218 INSERT INTO t3 VALUES('2008-02-29');
219 SELECT MONTHNAME(c1) FROM t3;
220 DROP TABLE t3;
221 CREATE TABLE t3(c1 DATE NOT NULL);
222 INSERT INTO t3 VALUES('1000-01-01');
223 INSERT INTO t3 VALUES('1999-12-31');
224 INSERT INTO t3 VALUES('2000-01-01');
225 INSERT INTO t3 VALUES('2006-12-25');
226 INSERT INTO t3 VALUES('2008-02-29');
227 SELECT QUARTER(c1) FROM t3;
228 DROP TABLE t3;
229 CREATE TABLE t3(c1 DATETIME NOT NULL);
230 INSERT INTO t3 VALUES('1000-01-01');
231 INSERT INTO t3 VALUES('1999-12-31');
232 INSERT INTO t3 VALUES('2000-01-01');
233 INSERT INTO t3 VALUES('2006-12-25');
234 INSERT INTO t3 VALUES('2008-02-29');
235 SELECT QUARTER(c1) FROM t3;
236 DROP TABLE t3;
237 CREATE TABLE t3(c1 TIMESTAMP 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 QUARTER(c1) FROM t3;
244 DROP TABLE t3;
245 CREATE TABLE t3(c1 DATE NOT NULL);
246 INSERT INTO t3 VALUES('1000-01-01');
247 INSERT INTO t3 VALUES('1999-12-31');
248 INSERT INTO t3 VALUES('2000-01-01');
249 INSERT INTO t3 VALUES('2006-12-25');
250 INSERT INTO t3 VALUES('2008-02-29');
251 SELECT TIMESTAMP(c1) FROM t3;
252 DROP TABLE t3;
253 CREATE TABLE t3(c1 DATETIME NOT NULL);
254 INSERT INTO t3 VALUES('1000-01-01');
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 TIMESTAMP(c1) FROM t3;
260 DROP TABLE t3;
261 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
262 INSERT INTO t3 VALUES('1000-01-01');
263 INSERT INTO t3 VALUES('1999-12-31');
264 INSERT INTO t3 VALUES('2000-01-01');
265 INSERT INTO t3 VALUES('2006-12-25');
266 INSERT INTO t3 VALUES('2008-02-29');
267 SELECT TIMESTAMP(c1) FROM t3;
268 DROP TABLE t3;
269 CREATE TABLE t3(c1 DATE NOT NULL);
270 INSERT INTO t3 VALUES('1000-01-01');
271 INSERT INTO t3 VALUES('1999-12-31');
272 INSERT INTO t3 VALUES('2000-01-01');
273 INSERT INTO t3 VALUES('2006-12-25');
274 INSERT INTO t3 VALUES('2008-02-29');
275 SELECT TO_DAYS(c1) FROM t3;
276 DROP TABLE t3;
277 CREATE TABLE t3(c1 DATETIME NOT NULL);
278 INSERT INTO t3 VALUES('1000-01-01');
279 INSERT INTO t3 VALUES('1999-12-31');
280 INSERT INTO t3 VALUES('2000-01-01');
281 INSERT INTO t3 VALUES('2006-12-25');
282 INSERT INTO t3 VALUES('2008-02-29');
283 SELECT TO_DAYS(c1) FROM t3;
284 DROP TABLE t3;
285 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
286 INSERT INTO t3 VALUES('1000-01-01');
287 INSERT INTO t3 VALUES('1999-12-31');
288 INSERT INTO t3 VALUES('2000-01-01');
289 INSERT INTO t3 VALUES('2006-12-25');
290 INSERT INTO t3 VALUES('2008-02-29');
291 SELECT TO_DAYS(c1) FROM t3;
292 DROP TABLE t3;
293 CREATE TABLE t3(c1 DATE NOT NULL);
294 INSERT INTO t3 VALUES('1000-01-01');
295 INSERT INTO t3 VALUES('1999-12-31');
296 INSERT INTO t3 VALUES('2000-01-01');
297 INSERT INTO t3 VALUES('2006-12-25');
298 INSERT INTO t3 VALUES('2008-02-29');
299 SELECT WEEK(c1) FROM t3;
300 DROP TABLE t3;
301 CREATE TABLE t3(c1 DATETIME NOT NULL);
302 INSERT INTO t3 VALUES('1000-01-01');
303 INSERT INTO t3 VALUES('1999-12-31');
304 INSERT INTO t3 VALUES('2000-01-01');
305 INSERT INTO t3 VALUES('2006-12-25');
306 INSERT INTO t3 VALUES('2008-02-29');
307 SELECT WEEK(c1) FROM t3;
308 DROP TABLE t3;
309 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
310 INSERT INTO t3 VALUES('1000-01-01');
311 INSERT INTO t3 VALUES('1999-12-31');
312 INSERT INTO t3 VALUES('2000-01-01');
313 INSERT INTO t3 VALUES('2006-12-25');
314 INSERT INTO t3 VALUES('2008-02-29');
315 SELECT WEEK(c1) FROM t3;
316 DROP TABLE t3;
317 CREATE TABLE t3(c1 DATE NOT NULL);
318 INSERT INTO t3 VALUES('1000-01-01');
319 INSERT INTO t3 VALUES('1999-12-31');
320 INSERT INTO t3 VALUES('2000-01-01');
321 INSERT INTO t3 VALUES('2006-12-25');
322 INSERT INTO t3 VALUES('2008-02-29');
323 SELECT WEEKDAY(c1) FROM t3;
324 DROP TABLE t3;
325 CREATE TABLE t3(c1 DATETIME NOT NULL);
326 INSERT INTO t3 VALUES('1000-01-01');
327 INSERT INTO t3 VALUES('1999-12-31');
328 INSERT INTO t3 VALUES('2000-01-01');
329 INSERT INTO t3 VALUES('2006-12-25');
330 INSERT INTO t3 VALUES('2008-02-29');
331 SELECT WEEKDAY(c1) FROM t3;
332 DROP TABLE t3;
333 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
334 INSERT INTO t3 VALUES('1000-01-01');
335 INSERT INTO t3 VALUES('1999-12-31');
336 INSERT INTO t3 VALUES('2000-01-01');
337 INSERT INTO t3 VALUES('2006-12-25');
338 INSERT INTO t3 VALUES('2008-02-29');
339 SELECT WEEKDAY(c1) FROM t3;
340 DROP TABLE t3;
341 CREATE TABLE t3(c1 DATE NOT NULL);
342 INSERT INTO t3 VALUES('1000-01-01');
343 INSERT INTO t3 VALUES('1999-12-31');
344 INSERT INTO t3 VALUES('2000-01-01');
345 INSERT INTO t3 VALUES('2006-12-25');
346 INSERT INTO t3 VALUES('2008-02-29');
347 SELECT WEEKOFYEAR(c1) FROM t3;
348 DROP TABLE t3;
349 CREATE TABLE t3(c1 DATETIME NOT NULL);
350 INSERT INTO t3 VALUES('1000-01-01');
351 INSERT INTO t3 VALUES('1999-12-31');
352 INSERT INTO t3 VALUES('2000-01-01');
353 INSERT INTO t3 VALUES('2006-12-25');
354 INSERT INTO t3 VALUES('2008-02-29');
355 SELECT WEEKOFYEAR(c1) FROM t3;
356 DROP TABLE t3;
357 CREATE TABLE t3(c1 TIMESTAMP 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 WEEKOFYEAR(c1) FROM t3;
364 DROP TABLE t3;
365 CREATE TABLE t3(c1 DATE NOT NULL);
366 INSERT INTO t3 VALUES('1000-01-01');
367 INSERT INTO t3 VALUES('1999-12-31');
368 INSERT INTO t3 VALUES('2000-01-01');
369 INSERT INTO t3 VALUES('2006-12-25');
370 INSERT INTO t3 VALUES('2008-02-29');
371 SELECT YEAR(c1) FROM t3;
372 DROP TABLE t3;
373 CREATE TABLE t3(c1 DATETIME NOT NULL);
374 INSERT INTO t3 VALUES('1000-01-01');
375 INSERT INTO t3 VALUES('1999-12-31');
376 INSERT INTO t3 VALUES('2000-01-01');
377 INSERT INTO t3 VALUES('2006-12-25');
378 INSERT INTO t3 VALUES('2008-02-29');
379 SELECT YEAR(c1) FROM t3;
380 DROP TABLE t3;
381 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
382 INSERT INTO t3 VALUES('1000-01-01');
383 INSERT INTO t3 VALUES('1999-12-31');
384 INSERT INTO t3 VALUES('2000-01-01');
385 INSERT INTO t3 VALUES('2006-12-25');
386 INSERT INTO t3 VALUES('2008-02-29');
387 SELECT YEAR(c1) FROM t3;
388 DROP TABLE t3;
389 CREATE TABLE t3(c1 DATE NOT NULL);
390 INSERT INTO t3 VALUES('1000-01-01');
391 INSERT INTO t3 VALUES('1999-12-31');
392 INSERT INTO t3 VALUES('2000-01-01');
393 INSERT INTO t3 VALUES('2006-12-25');
394 INSERT INTO t3 VALUES('2008-02-29');
395 SELECT YEARWEEK(c1) FROM t3;
396 DROP TABLE t3;
397 CREATE TABLE t3(c1 DATETIME NOT NULL);
398 INSERT INTO t3 VALUES('1000-01-01');
399 INSERT INTO t3 VALUES('1999-12-31');
400 INSERT INTO t3 VALUES('2000-01-01');
401 INSERT INTO t3 VALUES('2006-12-25');
402 INSERT INTO t3 VALUES('2008-02-29');
403 SELECT YEARWEEK(c1) FROM t3;
404 DROP TABLE t3;
405 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
406 INSERT INTO t3 VALUES('1000-01-01');
407 INSERT INTO t3 VALUES('1999-12-31');
408 INSERT INTO t3 VALUES('2000-01-01');
409 INSERT INTO t3 VALUES('2006-12-25');
410 INSERT INTO t3 VALUES('2008-02-29');
411 SELECT YEARWEEK(c1) FROM t3;
412 DROP TABLE t3;
413 SET sql_mode=default;