select * from table t where t.starttime >= '2023-01-03 00:00:00' and t.starttime <= '2023-01-04 00:00:00'
