1.查询最近1小时的数据,其中createtime是日期型数据
SELECT id,createtime FROM orders WHERE createtime BETWEEN sysdate-interval '1' hour AND SYSDATE
2. 转换日期型字段为时间戳。使用日期时间型字段减去1970-01-01 08:00:00,乘86400,生成时间戳。
SELECT id,createtime FROM orders WHERE (createtime - to_date('1970-01-01 08:00:00', 'yyyy-mm-dd hh24:mi:ss')) * 86400 BETWEEN '1670169600' AND '1670255999'