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!

systimestamp, sysdate and substraction

34MCA2K2Mar 17 2015 — edited Mar 18 2015

Hi Experts!

Whatever is happening is really stumping me out

Database version - Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

select sessiontimezone, dbtimezone, systimestamp, sysdate from dual

the column of sample_table

updated_ts timestamp(6)

When I execute following query

select sysdate - updated_ts,

   systimestamp - updated\_ts SUB\_SYSTIMESTAMP,

   updated\_ts,

   sysdate,

   systimestamp

from sample_table

I am trying very hard to derive any explanation out of this.

Thank you in advance!

This post has been answered by odie_63 on Mar 17 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2015

Added on Mar 17 2015

7 comments

359 views