-
oracle date in seconds
Hi,
the date in oracle is stored in seconds (like 1246067125) and i'm unable to convert it into calender date and i also need converting calender date into seconds (like 1246067125)
i tried some thing like
select to_date('01/01/1970','DD/MM/YYYY') + trunc(creation_date/86400) from table; but i'm not sure about it
BTW - how to insert calender date into oracle, where date is stored in seconds..
Thanks in advance
ram
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
|