Home
last modified time | relevance | path

Searched refs:INTERVAL (Results 1 – 25 of 4583) sorted by relevance

12345678910>>...184

/dports/sysutils/symon/symon-2.88/symux/
H A Dc_smrrds.sh32 INTERVAL=${INTERVAL:-5}
102 INTERVAL=$i
217 DS:debug0:GAUGE:$INTERVAL:U:U DS:debug1:GAUGE:$INTERVAL:U:U \
218 DS:debug2:GAUGE:$INTERVAL:U:U DS:debug3:GAUGE:$INTERVAL:U:U \
219 DS:debug4:GAUGE:$INTERVAL:U:U DS:debug5:GAUGE:$INTERVAL:U:U \
220 DS:debug6:GAUGE:$INTERVAL:U:U DS:debug7:GAUGE:$INTERVAL:U:U \
221 DS:debug8:GAUGE:$INTERVAL:U:U DS:debug9:GAUGE:$INTERVAL:U:U \
222 DS:debug10:GAUGE:$INTERVAL:U:U DS:debug11:GAUGE:$INTERVAL:U:U \
226 DS:debug18:GAUGE:$INTERVAL:U:U DS:debug19:GAUGE:$INTERVAL:U:U
234 DS:procsz:GAUGE:$INTERVAL:0:U DS:rsssz:GAUGE:$INTERVAL:0:U
[all …]
/dports/x11-toolkits/libdazzle/libdazzle-3.42.0/tests/
H A Dtest-panel.c10 #define INTERVAL 500 macro
17 { INTERVAL, COMMAND_SHOW },
18 { INTERVAL, COMMAND_HIDE },
19 { INTERVAL, COMMAND_SHOW },
20 { INTERVAL, COMMAND_HIDE },
21 { INTERVAL, COMMAND_SHOW },
22 { INTERVAL, COMMAND_HIDE },
23 { INTERVAL, COMMAND_SHOW },
24 { INTERVAL, COMMAND_HIDE },
25 { INTERVAL, COMMAND_SHOW },
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs264_subdate_function.result10 SUBDATE('2000-01-01', INTERVAL 1 DAY)
13 t1_d SUBDATE(t1_d, INTERVAL 5 MICROSECOND)
19 t1_d SUBDATE(t1_d, INTERVAL 5 SECOND)
25 t1_d SUBDATE(t1_d, INTERVAL 5 MINUTE)
31 t1_d SUBDATE(t1_d, INTERVAL 5 HOUR)
37 t1_d SUBDATE(t1_d, INTERVAL 5 DAY)
43 t1_d SUBDATE(t1_d, INTERVAL 5 WEEK)
49 t1_d SUBDATE(t1_d, INTERVAL 5 MONTH)
55 t1_d SUBDATE(t1_d, INTERVAL 5 QUARTER)
61 t1_d SUBDATE(t1_d, INTERVAL 5 YEAR)
[all …]
H A Dmcs92_date_functions.result30 t1_dt DATE_ADD(t1_dt, INTERVAL 1 SECOND)
37 t1_dt DATE_ADD(t1_dt, INTERVAL -1 SECOND)
44 t1_dt DATE_ADD(t1_dt, INTERVAL 1 DAY)
51 t1_dt DATE_ADD(t1_dt, INTERVAL -1 DAY)
58 t1_dt DATE_ADD(t1_dt, INTERVAL 1 MONTH)
65 t1_dt DATE_ADD(t1_dt, INTERVAL -1 MONTH)
72 t1_dt DATE_ADD(t1_dt, INTERVAL 0 MONTH)
149 t1_dt DATE_ADD(t1_dt, INTERVAL 12 HOUR)
156 t1_dt DATE_ADD(t1_dt, INTERVAL -1 HOUR)
177 t1_dt DATE_SUB(t1_dt, INTERVAL 1 DAY)
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs264_subdate_function.result10 SUBDATE('2000-01-01', INTERVAL 1 DAY)
13 t1_d SUBDATE(t1_d, INTERVAL 5 MICROSECOND)
19 t1_d SUBDATE(t1_d, INTERVAL 5 SECOND)
25 t1_d SUBDATE(t1_d, INTERVAL 5 MINUTE)
31 t1_d SUBDATE(t1_d, INTERVAL 5 HOUR)
37 t1_d SUBDATE(t1_d, INTERVAL 5 DAY)
43 t1_d SUBDATE(t1_d, INTERVAL 5 WEEK)
49 t1_d SUBDATE(t1_d, INTERVAL 5 MONTH)
55 t1_d SUBDATE(t1_d, INTERVAL 5 QUARTER)
61 t1_d SUBDATE(t1_d, INTERVAL 5 YEAR)
[all …]
H A Dmcs92_date_functions.result30 t1_dt DATE_ADD(t1_dt, INTERVAL 1 SECOND)
37 t1_dt DATE_ADD(t1_dt, INTERVAL -1 SECOND)
44 t1_dt DATE_ADD(t1_dt, INTERVAL 1 DAY)
51 t1_dt DATE_ADD(t1_dt, INTERVAL -1 DAY)
58 t1_dt DATE_ADD(t1_dt, INTERVAL 1 MONTH)
65 t1_dt DATE_ADD(t1_dt, INTERVAL -1 MONTH)
72 t1_dt DATE_ADD(t1_dt, INTERVAL 0 MONTH)
149 t1_dt DATE_ADD(t1_dt, INTERVAL 12 HOUR)
156 t1_dt DATE_ADD(t1_dt, INTERVAL -1 HOUR)
177 t1_dt DATE_SUB(t1_dt, INTERVAL 1 DAY)
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/
H A Dmcs264_subdate_function.test20 SELECT SUBDATE('2000-01-01', INTERVAL 1 DAY) FROM t1 LIMIT 1;
23 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 SECOND) FROM t1 ORDER BY 1;
24 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 MINUTE) FROM t1 ORDER BY 1;
25 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 HOUR) FROM t1 ORDER BY 1;
26 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 DAY) FROM t1 ORDER BY 1;
27 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 WEEK) FROM t1 ORDER BY 1;
28 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 MONTH) FROM t1 ORDER BY 1;
29 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 QUARTER) FROM t1 ORDER BY 1;
30 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 YEAR) FROM t1 ORDER BY 1;
46 SELECT t1_dt, SUBDATE(t1_dt, INTERVAL 5 HOUR) FROM t1 ORDER BY 1;
[all …]
H A Dmcs92_date_functions.test25 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL 1 SECOND) FROM t1;
26 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL -1 SECOND) FROM t1;
27 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL 1 DAY) FROM t1;
28 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL -1 DAY) FROM t1;
29 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL 1 MONTH) FROM t1;
30 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL -1 MONTH) FROM t1;
31 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL 0 MONTH) FROM t1;
42 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL 12 HOUR) FROM t1;
43 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL -1 HOUR) FROM t1;
47 SELECT t1_dt, DATE_SUB(t1_dt, INTERVAL 1 DAY) FROM t1;
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/
H A Dmcs264_subdate_function.test20 SELECT SUBDATE('2000-01-01', INTERVAL 1 DAY) FROM t1 LIMIT 1;
23 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 SECOND) FROM t1 ORDER BY 1;
24 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 MINUTE) FROM t1 ORDER BY 1;
25 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 HOUR) FROM t1 ORDER BY 1;
26 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 DAY) FROM t1 ORDER BY 1;
27 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 WEEK) FROM t1 ORDER BY 1;
28 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 MONTH) FROM t1 ORDER BY 1;
29 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 QUARTER) FROM t1 ORDER BY 1;
30 SELECT t1_d, SUBDATE(t1_d, INTERVAL 5 YEAR) FROM t1 ORDER BY 1;
46 SELECT t1_dt, SUBDATE(t1_dt, INTERVAL 5 HOUR) FROM t1 ORDER BY 1;
[all …]
H A Dmcs92_date_functions.test25 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL 1 SECOND) FROM t1;
26 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL -1 SECOND) FROM t1;
27 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL 1 DAY) FROM t1;
28 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL -1 DAY) FROM t1;
29 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL 1 MONTH) FROM t1;
30 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL -1 MONTH) FROM t1;
31 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL 0 MONTH) FROM t1;
42 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL 12 HOUR) FROM t1;
43 SELECT t1_dt, DATE_ADD(t1_dt, INTERVAL -1 HOUR) FROM t1;
47 SELECT t1_dt, DATE_SUB(t1_dt, INTERVAL 1 DAY) FROM t1;
[all …]
/dports/editors/emacs-devel/emacs-4d1968b/src/
H A Dintervals.h155 set_interval_parent (INTERVAL i, INTERVAL parent) in set_interval_parent()
245 extern void copy_properties (INTERVAL, INTERVAL);
246 extern bool intervals_equal (INTERVAL, INTERVAL);
252 extern INTERVAL split_interval_right (INTERVAL, ptrdiff_t)
254 extern INTERVAL split_interval_left (INTERVAL, ptrdiff_t);
255 extern INTERVAL find_interval (INTERVAL, ptrdiff_t);
256 extern INTERVAL next_interval (INTERVAL);
257 extern INTERVAL previous_interval (INTERVAL);
258 extern INTERVAL merge_interval_left (INTERVAL);
264 extern INTERVAL balance_intervals (INTERVAL);
[all …]
/dports/editors/emacs/emacs-27.2/src/
H A Dintervals.h152 set_interval_parent (INTERVAL i, INTERVAL parent) in set_interval_parent()
242 extern void copy_properties (INTERVAL, INTERVAL);
243 extern bool intervals_equal (INTERVAL, INTERVAL);
249 extern INTERVAL split_interval_right (INTERVAL, ptrdiff_t);
250 extern INTERVAL split_interval_left (INTERVAL, ptrdiff_t);
251 extern INTERVAL find_interval (INTERVAL, ptrdiff_t);
252 extern INTERVAL next_interval (INTERVAL);
253 extern INTERVAL previous_interval (INTERVAL);
254 extern INTERVAL merge_interval_left (INTERVAL);
260 extern INTERVAL balance_intervals (INTERVAL);
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/include/
H A Dctype_datetime.inc21 SELECT CHARSET('2013-11-15 00:41:28' - INTERVAL 7 DAY);
22 SELECT COERCIBILITY('2013-11-15 00:41:28' - INTERVAL 7 DAY);
23 SELECT CHARSET(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
24 SELECT COERCIBILITY(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
25 SELECT CHARSET(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
26 SELECT COERCIBILITY(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
30 SELECT CHARSET(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
32 SELECT HEX(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
43 SELECT HEX(CONCAT(a,'2001-01-08 00:00:00' - INTERVAL 7 DAY)) FROM t1;
51 SELECT * FROM t1 WHERE t < '2013-11-15 00:41:28' - INTERVAL 7 DAY;
[all …]
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/include/
H A Dctype_datetime.inc21 SELECT CHARSET('2013-11-15 00:41:28' - INTERVAL 7 DAY);
22 SELECT COERCIBILITY('2013-11-15 00:41:28' - INTERVAL 7 DAY);
23 SELECT CHARSET(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
24 SELECT COERCIBILITY(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
25 SELECT CHARSET(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
26 SELECT COERCIBILITY(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
30 SELECT CHARSET(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
32 SELECT HEX(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
43 SELECT HEX(CONCAT(a,'2001-01-08 00:00:00' - INTERVAL 7 DAY)) FROM t1;
51 SELECT * FROM t1 WHERE t < '2013-11-15 00:41:28' - INTERVAL 7 DAY;
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/include/
H A Dctype_datetime.inc21 SELECT CHARSET('2013-11-15 00:41:28' - INTERVAL 7 DAY);
22 SELECT COERCIBILITY('2013-11-15 00:41:28' - INTERVAL 7 DAY);
23 SELECT CHARSET(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
24 SELECT COERCIBILITY(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
25 SELECT CHARSET(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
26 SELECT COERCIBILITY(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
30 SELECT CHARSET(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
32 SELECT HEX(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
43 SELECT HEX(CONCAT(a,'2001-01-08 00:00:00' - INTERVAL 7 DAY)) FROM t1;
51 SELECT * FROM t1 WHERE t < '2013-11-15 00:41:28' - INTERVAL 7 DAY;
[all …]
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/include/
H A Dctype_datetime.inc21 SELECT CHARSET('2013-11-15 00:41:28' - INTERVAL 7 DAY);
22 SELECT COERCIBILITY('2013-11-15 00:41:28' - INTERVAL 7 DAY);
23 SELECT CHARSET(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
24 SELECT COERCIBILITY(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
25 SELECT CHARSET(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
26 SELECT COERCIBILITY(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
30 SELECT CHARSET(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
32 SELECT HEX(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
43 SELECT HEX(CONCAT(a,'2001-01-08 00:00:00' - INTERVAL 7 DAY)) FROM t1;
51 SELECT * FROM t1 WHERE t < '2013-11-15 00:41:28' - INTERVAL 7 DAY;
[all …]
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/include/
H A Dctype_datetime.inc21 SELECT CHARSET('2013-11-15 00:41:28' - INTERVAL 7 DAY);
22 SELECT COERCIBILITY('2013-11-15 00:41:28' - INTERVAL 7 DAY);
23 SELECT CHARSET(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
24 SELECT COERCIBILITY(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
25 SELECT CHARSET(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
26 SELECT COERCIBILITY(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
30 SELECT CHARSET(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
32 SELECT HEX(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
43 SELECT HEX(CONCAT(a,'2001-01-08 00:00:00' - INTERVAL 7 DAY)) FROM t1;
51 SELECT * FROM t1 WHERE t < '2013-11-15 00:41:28' - INTERVAL 7 DAY;
[all …]
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/include/
H A Dctype_datetime.inc21 SELECT CHARSET('2013-11-15 00:41:28' - INTERVAL 7 DAY);
22 SELECT COERCIBILITY('2013-11-15 00:41:28' - INTERVAL 7 DAY);
23 SELECT CHARSET(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
24 SELECT COERCIBILITY(TIMESTAMP'2013-11-15 00:41:28' - INTERVAL 7 DAY);
25 SELECT CHARSET(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
26 SELECT COERCIBILITY(CONCAT('2013-11-15 00:41:28' - INTERVAL 7 DAY));
30 SELECT CHARSET(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
32 SELECT HEX(CONCAT('','2001-01-08 00:00:00' - INTERVAL 7 DAY));
43 SELECT HEX(CONCAT(a,'2001-01-08 00:00:00' - INTERVAL 7 DAY)) FROM t1;
51 SELECT * FROM t1 WHERE t < '2013-11-15 00:41:28' - INTERVAL 7 DAY;
[all …]
/dports/databases/mysql55-client/mysql-5.5.62/mysql-test/r/
H A Dfunc_time.result283 INTERVAL 1 DAY + "1997-12-31"
625 date_add(datetime, INTERVAL 1 YEAR)
628 date_add(date,INTERVAL 1 SECOND)
631 date_add(date,INTERVAL 1 MINUTE)
634 date_add(date,INTERVAL 1 HOUR)
637 date_add(date,INTERVAL 1 DAY)
640 date_add(date,INTERVAL 1 MONTH)
643 date_add(date,INTERVAL 1 YEAR)
667 date_add(date,INTERVAL "1" WEEK)
670 date_add(date,INTERVAL "1" QUARTER)
[all …]
/dports/deskutils/calcurse/calcurse-4.7.1/test/
H A Drecur-009.sh80 * Every Sunday and Monday, every other year (FREQ=YEARLY;INTERVAL=2;BYDAY=SU,MO)
83 * Every Sunday and Monday, every other year (FREQ=YEARLY;INTERVAL=2;BYDAY=SU,MO)
90 * Every Sunday and Monday, every other year (FREQ=YEARLY;INTERVAL=2;BYDAY=SU,MO)
93 * Every Sunday and Monday, every other year (FREQ=YEARLY;INTERVAL=2;BYDAY=SU,MO)
100 * Every Sunday and Monday, every other year (FREQ=YEARLY;INTERVAL=2;BYDAY=SU,MO)
103 * Every Sunday and Monday, every other year (FREQ=YEARLY;INTERVAL=2;BYDAY=SU,MO)
112 * Every Sunday and Monday, every other year (FREQ=YEARLY;INTERVAL=2;BYDAY=SU,MO)
115 * Every Sunday and Monday, every other year (FREQ=YEARLY;INTERVAL=2;BYDAY=SU,MO)
122 * Every Sunday and Monday, every other year (FREQ=YEARLY;INTERVAL=2;BYDAY=SU,MO)
125 * Every Sunday and Monday, every other year (FREQ=YEARLY;INTERVAL=2;BYDAY=SU,MO)
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/
H A Dfunc_date_add.test39 having mts < DATE_SUB(NOW(),INTERVAL 3 MONTH);
41 having DATE_ADD(mts,INTERVAL 3 MONTH) < NOW();
51 insert into t1 (d) select date_sub('2000-01-01', INTERVAL 2001 YEAR);
55 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
56 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
62 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
63 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
75 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 DAY;
76 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 MONTH;
77 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 YEAR;
[all …]
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/main/
H A Dfunc_date_add.test39 having mts < DATE_SUB(NOW(),INTERVAL 3 MONTH);
41 having DATE_ADD(mts,INTERVAL 3 MONTH) < NOW();
51 insert into t1 (d) select date_sub('2000-01-01', INTERVAL 2001 YEAR);
55 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
56 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
62 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
63 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
75 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 DAY;
76 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 MONTH;
77 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 YEAR;
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/
H A Dfunc_date_add.test39 having mts < DATE_SUB(NOW(),INTERVAL 3 MONTH);
41 having DATE_ADD(mts,INTERVAL 3 MONTH) < NOW();
51 insert into t1 (d) select date_sub('2000-01-01', INTERVAL 2001 YEAR);
55 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
56 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
62 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
63 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
75 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 DAY;
76 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 MONTH;
77 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 YEAR;
[all …]
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/main/
H A Dfunc_date_add.test39 having mts < DATE_SUB(NOW(),INTERVAL 3 MONTH);
41 having DATE_ADD(mts,INTERVAL 3 MONTH) < NOW();
51 insert into t1 (d) select date_sub('2000-01-01', INTERVAL 2001 YEAR);
55 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
56 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
62 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
63 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
75 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 DAY;
76 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 MONTH;
77 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 YEAR;
[all …]
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/main/
H A Dfunc_date_add.test39 having mts < DATE_SUB(NOW(),INTERVAL 3 MONTH);
41 having DATE_ADD(mts,INTERVAL 3 MONTH) < NOW();
51 insert into t1 (d) select date_sub('2000-01-01', INTERVAL 2001 YEAR);
55 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
56 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
62 insert into t1 values (date_add(NULL, INTERVAL 1 DAY));
63 insert into t1 values (date_add('2000-01-04', INTERVAL NULL DAY));
75 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 DAY;
76 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 MONTH;
77 SELECT CAST('2006-09-26' AS DATE) + INTERVAL 1 YEAR;
[all …]

12345678910>>...184