我尝试了很多方法,但都找不到。我正在构建一个查询,希望获得小时、分钟和秒之间的数据。
已经尝试过的方法如:
SELECT * FROM MYTABLENAME TB
WHERE (TB.DATE BETWEEN '25/11/2013 00:00:00' AND '25/11/2013 23:59:59')
您可以使用类似的东西
select * from TB
WHERE cast(date_time_attribute as time ) between '10:00:00' and '23:00:00'
要对日期施加限制,您可以简单地添加此->
select * from TB
WHERE ( cast(date_time_attribute as time ) between '10:00:00' and '23:00:00' )
AND date(date_time_attribute) = 'dd:mm:yyyy'
date_time_attribute是包含日期时间的属性