Skip to Main Content

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!

Convert Current Timestamp to Milliseconds

721178Jun 9 2011 — edited Jun 9 2011
Hi,

Can you please help me to convert the current timestamp into UTC (millisecond) format?
My requirement is to convert the o/p of SYSTIMESTAMP - '01-Jan-1970' to milliseconds. The outcome should show number of milliseconds between these two timestamps.

Thanks for your time.

Edited by: Kiran Deep on Jun 9, 2011 2:52 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2011
Added on Jun 9 2011
3 comments
35,625 views