-
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
-
Do you have a field that stores when a record was inserted?
Jeff Hunter
-
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 ?
svk
-
u could probably use logminer. see docs for hwo 2 do it.
OCP DBA 8i
ocpwannabe@yahoo.com
-----------------------------
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');
svk
-
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')
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|