Skip to Main Content
Forums

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!

Update date/time in UNIX timestamp format

759927Jun 25 2010 — edited Jun 29 2010
The datetime in my Oracle DB is being stored in UNIX Date Time format.

Is there a way I can set the date/time using an UPDATE statement in such a case.

for eg:
select id, creation_date, expiration_date from skel;


id creation_date expiration_date

400019 1213726470
400020 1213733052
400005 1210867973
400018 1213723608

I am looking to set the expiration date as creation_date + 1 year.

Could you please advise?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2010
Added on Jun 25 2010
4 comments
2,725 views