[size=medium]select * from DifficultyPopulation where createDate [color=red]between [/color][color=blue]to_date[/color]('2013-06-26 00:00:00','yyyy-mm-dd hh24:mi:ss') [color=red]and[/color] [color=blue]to_date[/color]('2013-06-26 23:59:59','yyyy-mm-dd hh24:mi:ss')
order by createDate desc
select * from up_date where update <= to_date('2007-09-07 00:00:00','yyyy-mm-dd hh24:mi:ss') and update >= to_date('2007-07-07 00:00:00','yyyy-mm-dd hh24:mi:ss')
[/size]
order by createDate desc
select * from up_date where update <= to_date('2007-09-07 00:00:00','yyyy-mm-dd hh24:mi:ss') and update >= to_date('2007-07-07 00:00:00','yyyy-mm-dd hh24:mi:ss')
[/size]