Phoenix时间范围查询

最新推荐文章于 2026-06-20 08:00:42 发布

原创最新推荐文章于 2026-06-20 08:00:42 发布 · 1.4k 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

Phoenix 专栏收录该内容

3 篇文章

订阅专栏

本文介绍两种在SQL中筛选特定日期范围记录的方法：使用BETWEEN和比较运算符(>和<)。通过具体示例展示了如何将字符串日期转换为日期类型，并进行有效的时间区间查询。

采用between

select * from table1 where cast(TO_DATE(start_time,'yyyyMMddHHmmss') as date) between cast(TO_DATE('20200514000000','yyyyMMddHHmmss') as date) and cast(TO_DATE('20200515000000','yyyyMMddHHmmss') as date);

采用比较运算符>和<

select start_time from table1 where cast(TO_DATE(start_time,'yyyyMMddHHmmss') as date) > cast(TO_DATE('20200514000000','yyyyMMddHHmmss') as date) and cast(TO_DATE(start_time,'yyyyMMddHHmmss') as date) <cast(TO_DATE('20200515000000','yyyyMMddHHmmss') as date);

between运行结果