/dports/sysutils/symon/symon-2.88/symux/ |
H A D | c_smrrds.sh | 32 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 D | test-panel.c | 10 #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 D | mcs264_subdate_function.result | 10 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 D | mcs92_date_functions.result | 30 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 D | mcs264_subdate_function.result | 10 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 D | mcs92_date_functions.result | 30 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 D | mcs264_subdate_function.test | 20 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 D | mcs92_date_functions.test | 25 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 D | mcs264_subdate_function.test | 20 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 D | mcs92_date_functions.test | 25 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 D | intervals.h | 155 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 D | intervals.h | 152 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 D | ctype_datetime.inc | 21 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 D | ctype_datetime.inc | 21 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 D | ctype_datetime.inc | 21 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 D | ctype_datetime.inc | 21 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 D | ctype_datetime.inc | 21 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 D | ctype_datetime.inc | 21 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 D | func_time.result | 283 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 D | recur-009.sh | 80 * 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 D | func_date_add.test | 39 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 D | func_date_add.test | 39 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 D | func_date_add.test | 39 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 D | func_date_add.test | 39 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 D | func_date_add.test | 39 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 …]
|