Oracle 中日期比较

 

 

select * from mytable 
where mydate between to_date('2010-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') 
                 and to_date('2010-02-02 00:00:00','yyyy-mm-dd hh24:mi:ss')


select * from mytable 
where mydate > to_date('2010-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') 
  and mydate < to_date('2010-02-02 00:00:00','yyyy-mm-dd hh24:mi:ss')