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!

Difference Between Timestamps in Milliseconds in Oracle

2618432Mar 24 2014 — edited Mar 24 2014

I have table test1 and have one column DOJ with timestamp datatype having few records as shown below. Here i need the difference im milliseconds between doj and systimestamp. SELECT DOJ FROM TEST1; DOJ ---------------------------- 21-MAR-14 09.25.34.514526000 21-MAR-14 09.25.34.520345000 22-MAR-14 09.25.34.523144000 22-MAR-14 09.25.34.527770000 23-MAR-14 09.25.34.532482000 23-MAR-14 09.25.34.535603000 24-MAR-14 09.25.34.538556000 24-MAR-14 09.25.34.541729000 SELECT SYSTIMESTAMP FROM DUAL; SYSTIMESTAMP -------------- 24-MAR-14 09.48.10.251556000 +00:00 Can some one please help me with this.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2014

Added on Mar 24 2014

4 comments

8,294 views