Oracle实现查询时间段的Sql语句两法,相比ORacle要查询时间段的Sql语句还是与Sql Server的Sql语句有区别的,下面举两种方法来说明在ORacle是如何查询时间段的:
第一种方法:between……and
select * from location t
where locationdate
Between to_date('2010-5-4 10:00:00','yyyy-mm-dd hh24:mi:ss')
And to_date('2010-5-4 15:00:00','yyyy-mm-dd hh24:mi:ss')
order by locationdate desc
第二种方法:.>=…,<=…
select t.* from location t where locationdate>=to_date('2010-5-4 10:00:00','yyyy-mm-dd hh24:mi:ss') and locationdate<=to_date('2010-5-4 15:00:00','yyyy-mm-dd hh24:mi:ss') order by locationdate desc