Phoenix时间范围查询

最新推荐文章于 2024-07-19 21:08:24 发布

RunningShare

最新推荐文章于 2024-07-19 21:08:24 发布

阅读量1.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： Phoenix

本文链接：https://blog.csdn.net/JacksonKing/article/details/106138515

Phoenix 专栏收录该内容

3 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

采用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运行结果