compare date with time

[programmer]

i want to find out the records in a table that was inserted starting yesterday 7.00 am and ending today 7.00 am
Thanks

[marist89]

Do you have a field that stores when a record was inserted?

[svk]

If you do not have a date column in your table that records the time when the record is created, its very difficult to find it.

How serious are you @ it ?

[ocpwannabe]

u could probably use logminer. see docs for hwo 2 do it.

[programmer]

yes i have to process on a data type field

[svk]

Then nothing else can be simpler :

select * from your_table
where your_date_column between to_date('12-DEC-2001 070000','DD-MON-YYYY HH24MISS') and to_date('13-DEC-2001 070000','DD-MON-YYYY HH24MISS');

[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')