数据库中begin_time为’2021-05-15 06:30:30’
1.select * from table where begin_time::date = ‘2021-05-15’
true
2.select * from table where begin_time::date = ‘2021-05-15 01:00:00’
true
3.select * from table where begin_time::date = ‘2021-05-15 01:00:00’::date
true
4.select * from table where begin_time = ‘2021-05-15 01:00:00’
false
5.category=‘2’ and end_time::time<‘2000-01-01 06:30:00’