i want to find out the records in a table that was inserted starting yesterday 7.00 am and ending today 7.00 am
Do you have a field that stores when a record was inserted?
"I pledge to stop eating sharks fin soup and will not do so under any circumstances."
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 ?
u could probably use logminer. see docs for hwo 2 do it.
OCP DBA 8i
When in doubt, pick 'C'.
yes i have to process on a data type field
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');
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')