SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to return start and end time in Unix epoch format

438181Oct 6 2006 — edited Oct 11 2006

Hi: I have a integer field (utime) in a table that stores the UNIX epoch time for a record. Every sunday around 2:00AM, I am running a query which should return records from last week. I want my condition to have the following in it's where

WHERE utime between
(convert sysdate-7 12:00AM to Unix time)
AND
(convert yesterday 11:59PM to Unix time)

Can someone help me create this convert?
Thanks
Ray

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2006

Added on Oct 6 2006

6 comments

908 views