github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/function/func_datetime_weekday.result (about) 1 SELECT weekday(date('2007-02-03 03:42:24')); 2 weekday(date('2007-02-03 03:42:24')) 3 5 4 SELECT weekday(NULL); 5 weekday(NULL) 6 null 7 create table t1(a tinyint, b SMALLINT, c bigint, d INT, e BIGINT, f FLOAT, g DOUBLE, h decimal(38,19), i DATE, k datetime, l TIMESTAMP, m char(255), n varchar(255)); 8 insert into t1 values(1, 1, 2, 43, 5, 35.5, 31.133, 14.314, "2012-03-10", "2012-03-12 10:03:12", "2022-03-12 13:03:12", "ab23c", "d5cf"); 9 insert into t1 values(71, 1, 2, 34, 5, 5.5, 341.13, 15.314, "2012-03-22", "2013-03-12 10:03:12", "2032-03-12 13:04:12", "abr23c", "3dcf"); 10 insert into t1 values(1, 1, 21, 4, 54, 53.5, 431.13, 14.394, "2011-03-12", "2015-03-12 10:03:12", "2002-03-12 13:03:12", "afbc", "dct5f"); 11 insert into t1 values(1, 71, 2, 34, 5, 5.5, 31.313, 124.314, "2012-01-12", "2019-03-12 10:03:12", "2013-03-12 13:03:12", "3abd1c", "dcvf"); 12 select weekday(a),weekday(b),weekday(c),weekday(d),weekday(e),weekday(f) from t1; 13 invalid argument function weekday, bad value [TINYINT] 14 select weekday(g),weekday(h),weekday(i),weekday(k),weekday(l),weekday(m),weekday(n) from t1; 15 invalid argument function weekday, bad value [DOUBLE] 16 drop table t1; 17 SELECT weekday("2015-09-03") as weekday; 18 weekday 19 3 20 SELECT weekday('20150904') as weekday; 21 weekday 22 4 23 SELECT weekday(1340124) as weekday; 24 invalid argument function weekday, bad value [BIGINT] 25 SELECT weekday(0.45133) as weekday; 26 invalid argument function weekday, bad value [DECIMAL128] 27 SELECT weekday(10) as weekday; 28 invalid argument function weekday, bad value [BIGINT] 29 SELECT weekday(1=1) as weekday; 30 invalid argument function weekday, bad value [BOOL] 31 SELECT weekday('2015-09-30') as weekday; 32 weekday 33 2 34 SELECT weekday('2015-0') as weekday; 35 invalid argument parsedate, bad value 2015-0 36 SELECT weekday('2015-09.30 12') as weekday; 37 invalid argument parsedate, bad value 2015-09.30 12 38 SELECT weekday('2015-09-26 08:09:22') AS weekday; 39 weekday 40 5 41 select weekday("2020-08"); 42 invalid argument parsedate, bad value 2020-08 43 select weekday("0000-00-00"); 44 invalid argument parsedate, bad value 0000-00-00 45 select weekday("-0001-03-03"); 46 invalid argument parsedate, bad value -0001-03-03 47 select weekday("10000-03-02"); 48 invalid argument parsedate, bad value 10000-03-02 49 select weekday("2021-13-09"); 50 invalid argument parsedate, bad value 2021-13-09 51 select weekday("2020-10-32"); 52 invalid argument parsedate, bad value 2020-10-32 53 SELECT weekday("2015-09-10")- weekday("2016-04-24"); 54 weekday("2015-09-10")- weekday("2016-04-24") 55 -3 56 SELECT weekday("2015-09-10")+ weekday("2016-04-24"); 57 weekday("2015-09-10")+ weekday("2016-04-24") 58 9 59 SELECT weekday("2015-09-10")*weekday("2016-04-24"); 60 weekday("2015-09-10")*weekday("2016-04-24") 61 18 62 SELECT weekday("2015-09-10")/weekday("2016-04-24"); 63 weekday("2015-09-10")/weekday("2016-04-24") 64 0.5000 65 SELECT weekday("2015-09-10")>weekday("2016-04-24"); 66 weekday("2015-09-10")>weekday("2016-04-24") 67 false 68 SELECT weekday("2015-09-10")<weekday("2016-04-24"); 69 weekday("2015-09-10")<weekday("2016-04-24") 70 true 71 SELECT weekday("2015-09-10")=weekday("2016-04-24"); 72 weekday("2015-09-10")=weekday("2016-04-24") 73 false 74 SELECT weekday("2015-09-10")<>weekday("2016-04-24"); 75 weekday("2015-09-10")<>weekday("2016-04-24") 76 true 77 SELECT weekday("2015-09-10")!=weekday("2016-04-24"); 78 weekday("2015-09-10")!=weekday("2016-04-24") 79 true 80 CREATE TABLE Product(Product_id INT, Product_name VARCHAR(100) NOT NULL,Buying_price DECIMAL(13, 2) NOT NULL,Selling_price DECIMAL(13, 2) NOT NULL,Selling_Date Date NOT NULL,PRIMARY KEY(Product_id)); 81 INSERT INTO Product(Product_name, Buying_price, Selling_price, Selling_Date) VALUES ('Audi Q8', 10000000.00, 15000000.00, '2018-01-26' ),('Volvo XC40', 2000000.00, 3000000.00, '2018-04-20' ),('Audi A6', 4000000.00, 5000000.00, '2018-07-25' ),('BMW X5', 5000500.00, 7006500.00, '2018-10-18' ),('Jaguar XF', 5000000, 7507000.00, '2019-01-27' ),('Mercedes-Benz C-Class', 4000000.00, 6000000.00, '2019-04-01' ),('Jaguar F-PACE', 5000000.00, 7000000.00, '2019-12-26' ),('Porsche Macan', 6500000.00, 8000000.00, '2020-04-16' ) ; 82 invalid input: invalid default value 83 SELECT weekday (Selling_Date) weekday, COUNT(Product_id) Product_Sold FROM Product GROUP BY weekday (Selling_Date) ORDER BY weekday (Selling_Date); 84 weekday Product_Sold 85 DROP TABLE Product; 86 drop table if exists t1; 87 create table t1(a INT, b date); 88 insert into t1 select weekday("2012-10-12"), "2012-10-12"; 89 insert into t1 select weekday("2004-04-24"), "2004-04-24"; 90 insert into t1 select weekday("2008-12-04"), "2008-12-04"; 91 select * from t1; 92 a b 93 4 2012-10-12 94 5 2004-04-24 95 3 2008-12-04 96 drop table t1; 97 drop table if exists t1; 98 create table t1(a INT, b date); 99 insert into t1 values(1, "2012-10-12"),(2, "2004-04-24"),(3, "2008-12-04"),(4, "2012-03-23"); 100 select * from t1 where weekday(b)<>0; 101 a b 102 1 2012-10-12 103 2 2004-04-24 104 3 2008-12-04 105 4 2012-03-23 106 drop table t1; 107 drop table if exists t1; 108 drop table if exists t2; 109 create table t1(a INT, b date); 110 create table t2(a INT, b date); 111 insert into t1 values(1, "2012-10-12"),(2, "2004-04-24"),(3, "2008-12-04"),(4, "2012-03-23"); 112 insert into t2 values(1, "2013-04-30"),(2, "1994-10-04"),(3, "2018-06-04"),(4, "2012-08-12"); 113 SELECT t1.a, t2.a FROM t1 JOIN t2 ON (weekday(t1.b) <> weekday(t2.b)); 114 a a 115 4 1 116 3 1 117 2 1 118 1 1 119 4 2 120 3 2 121 2 2 122 1 2 123 4 3 124 3 3 125 2 3 126 1 3 127 4 4 128 3 4 129 2 4 130 1 4 131 drop table t1; 132 drop table t2; 133 drop table if exists t1; 134 create table t1(a INT, b date); 135 insert into t1 values(1, "2012-10-12"),(1, "2012-07-12"),(2, "2004-04-24"),(3, "2008-12-04"),(4, "2012-03-23"); 136 select b from t1 group by b having weekday(b)>0; 137 b 138 2012-10-12 139 2012-07-12 140 2004-04-24 141 2008-12-04 142 2012-03-23 143 drop table t1; 144 drop table if exists t1; 145 create table t1(a INT, b date); 146 insert into t1 values(1, "2012-10-12"),(1, "2012-07-12"),(2, "2004-04-24"),(3, "2004-04-24"),(3, "2008-12-04"),(4, "2012-03-23"); 147 select distinct weekday(b) from t1; 148 weekday(b) 149 4 150 3 151 5 152 drop table t1; 153 CREATE TABLE t3(c1 DATE NOT NULL); 154 INSERT INTO t3 VALUES('2000-01-01'); 155 INSERT INTO t3 VALUES('1999-12-31'); 156 INSERT INTO t3 VALUES('2000-01-01'); 157 INSERT INTO t3 VALUES('2006-12-25'); 158 INSERT INTO t3 VALUES('2008-02-29'); 159 SELECT WEEKDAY(c1) FROM t3; 160 WEEKDAY(c1) 161 5 162 4 163 5 164 0 165 4 166 DROP TABLE t3; 167 CREATE TABLE t3(c1 DATETIME NOT NULL); 168 INSERT INTO t3 VALUES('2000-01-01'); 169 INSERT INTO t3 VALUES('1999-12-31'); 170 INSERT INTO t3 VALUES('2000-01-01'); 171 INSERT INTO t3 VALUES('2006-12-25'); 172 INSERT INTO t3 VALUES('2008-02-29'); 173 SELECT WEEKDAY(c1) FROM t3; 174 WEEKDAY(c1) 175 5 176 4 177 5 178 0 179 4 180 DROP TABLE t3; 181 CREATE TABLE t3(c1 TIMESTAMP NOT NULL); 182 INSERT INTO t3 VALUES('2000-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 WEEKDAY(c1) FROM t3; 188 WEEKDAY(c1) 189 5 190 4 191 5 192 0 193 4 194 DROP TABLE t3;