对于条件语句where time between '2024-01-08' and '2024-01-10'
当time类型是Date时,等价于: where time >= '2024-01-08' and time <= '2024-01-10'
但当time变为DateTime类型的时候,该语句会等价于where time >= '2024-01-08 00:00:00' and time <= '2024-01-10 00:00:00'
,导致1月10日当天数据无法查到。
建议直接使用 where time >= '2024-01-08' and time < '2024-01-11'
doris数据库:where time >= '2024-01-08' and time < DATE_ADD('2024-01-10', INTERVAL 1 DAY)