compare date with time

[marist89]

SELECT * FROM xyz
WHERE inserted_date > to_date('20011210 07:00','yyyymmdd hh24:mi')
AND inserted_date <= to_date('20011211 07:00','yyyymmdd hh24:mi')