Home
last modified time | relevance | path

Searched refs:WEEK (Results 1 – 25 of 1961) sorted by relevance

12345678910>>...79

/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs279_week_function.result13 WEEK('2020-10-12')
16 WEEK('2020-05-22')
22 WEEK('12:13:14')
27 t1_DATE WEEK(t1_DATE)
31 t1_DATE WEEK(t1_DATE, 0)
35 t1_DATE WEEK(t1_DATE, 1)
39 t1_DATE WEEK(t1_DATE, 2)
43 t1_DATE WEEK(t1_DATE, 3)
47 t1_DATE WEEK(t1_DATE, 4)
51 t1_DATE WEEK(t1_DATE, 5)
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/
H A Dmcs279_week_function.result13 WEEK('2020-10-12')
16 WEEK('2020-05-22')
22 WEEK('12:13:14')
27 t1_DATE WEEK(t1_DATE)
31 t1_DATE WEEK(t1_DATE, 0)
35 t1_DATE WEEK(t1_DATE, 1)
39 t1_DATE WEEK(t1_DATE, 2)
43 t1_DATE WEEK(t1_DATE, 3)
47 t1_DATE WEEK(t1_DATE, 4)
51 t1_DATE WEEK(t1_DATE, 5)
[all …]
/dports/sysutils/linrename/util-linux-2.25.2/tests/ts/cal/
H A Dweekarg36 WEEK="--week=40"
39 $TS_CMD_CAL -3m $WEEK $MYTIME
45 $TS_CMD_CAL -3s $WEEK $MYTIME
52 $TS_CMD_CAL -3mj $WEEK $MYTIME
58 $TS_CMD_CAL -3sj $WEEK $MYTIME
64 $TS_CMD_CAL -m $WEEK $MYTIME
70 $TS_CMD_CAL -s $WEEK $MYTIME
77 $TS_CMD_CAL -mj $WEEK $MYTIME
83 $TS_CMD_CAL -sj $WEEK $MYTIME
90 WEEK="--week=53"
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/
H A Dmcs279_week_function.test2 # WEEK() function
23 SELECT WEEK('2020-10-12') FROM t1 LIMIT 1;
24 SELECT WEEK('2020-05-22') FROM t1 LIMIT 1;
25 SELECT WEEK('2020-02-13 12:13:14') FROM t1 LIMIT 1;
26 SELECT WEEK('12:13:14') FROM t1 LIMIT 1;
28 SELECT t1_DATE, WEEK(t1_DATE) FROM t1 ORDER BY 1;
29 SELECT t1_DATE, WEEK(t1_DATE, 0) FROM t1 ORDER BY 1;
30 SELECT t1_DATE, WEEK(t1_DATE, 1) FROM t1 ORDER BY 1;
31 SELECT t1_DATE, WEEK(t1_DATE, 2) FROM t1 ORDER BY 1;
32 SELECT t1_DATE, WEEK(t1_DATE, 3) FROM t1 ORDER BY 1;
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/mysql-test/columnstore/basic/t/
H A Dmcs279_week_function.test2 # WEEK() function
23 SELECT WEEK('2020-10-12') FROM t1 LIMIT 1;
24 SELECT WEEK('2020-05-22') FROM t1 LIMIT 1;
25 SELECT WEEK('2020-02-13 12:13:14') FROM t1 LIMIT 1;
26 SELECT WEEK('12:13:14') FROM t1 LIMIT 1;
28 SELECT t1_DATE, WEEK(t1_DATE) FROM t1 ORDER BY 1;
29 SELECT t1_DATE, WEEK(t1_DATE, 0) FROM t1 ORDER BY 1;
30 SELECT t1_DATE, WEEK(t1_DATE, 1) FROM t1 ORDER BY 1;
31 SELECT t1_DATE, WEEK(t1_DATE, 2) FROM t1 ORDER BY 1;
32 SELECT t1_DATE, WEEK(t1_DATE, 3) FROM t1 ORDER BY 1;
[all …]
/dports/devel/util-linux/util-linux-2.36/tests/ts/cal/
H A Dweekarg64 WEEK="--week=40"
65 call_cal "Gregorian - Monday-based, $PWEEK, 3 month" -3m $WEEK $MYTIME
66 call_cal "Gregorian - Sunday-based, $PWEEK, 3 month" -3s $WEEK $MYTIME
69 call_cal "Gregorian - Monday-based, $PWEEK, 1 month" -m $WEEK $MYTIME
70 call_cal "Gregorian - Sunday-based, $PWEEK, 1 month" -s $WEEK $MYTIME
71 call_cal "Julian - Monday-based, $PWEEK, 1 month" -mj $WEEK $MYTIME
72 call_cal "Julian - Sunday-based, $PWEEK, 1 month" -sj $WEEK $MYTIME
80 WEEK="--week=53"
81 call_cal "Gregorian - Monday-based, $PWEEK, 1 month" -1m $WEEK $MYTIME
89 WEEK="--week=54"
[all …]
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]
/dports/databases/mysql55-client/mysql-5.5.62/mysql-test/suite/sys_vars/r/
H A Ddefault_week_format_func.result7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
32 WEEK('2008-01-20')
40 WEEK('2008-01-20')
48 WEEK('2008-01-20')
56 WEEK('2008-01-20')
[all …]

12345678910>>...79