# bool statement ok create table test1 (a boolean) statement ok INSERT INTO test1 VALUES (TRUE) statement ok INSERT INTO test1 VALUES (false) query B rowsort select * from test1 order by a ---- false true statement ok drop table test1 # date statement ok create table t (v1 date not null); statement ok insert into t values('2020-01-01'); query I select v1 from t where v1 < date '2021-01-01'; ---- 2020-01-01 statement ok drop table t