107
107
CREATE TABLE t1 (f1 time);
108
108
INSERT INTO t1 VALUES ('24:00:00');
110
110
SELECT CAST('24:00:00' as time) = (select f1 from t1);
111
111
CAST('24:00:00' as time) = (select f1 from t1)
114
114
CREATE TABLE t1(f1 time, f2 time);
115
115
INSERT INTO t1 VALUES('20:00:00','150:00:00');
117
117
select 1 from t1 where cast('100:00:00' as time) between f1 and f2;