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 doesn't use dbtimezone?

WestDraytonJan 19 2010 — edited Jan 19 2010

I see that CURRENT_TIMESTAMP uses session' timesone "+02:00", it ends with "+02:00" as needed "19.01.2010 13:28:30,288664000 *+02:00*".
But i don't see that SYSTIMESTAMP uses dbtimezone "+00:00", it doesn't have at the end "+00:00", see: "19.01.2010 13:28:30,288658000 +02:00".
Why so?

---

CURRENT_TIMESTAMP returns the current date and time in the session time zone

http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/functions043.htm#SQLRF00629

SYSTIMESTAMP returns the system date, including fractional seconds and time zone, of the system on which the database resides.

http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/functions190.htm#SQLRF06125

In Oracle Sql Developer i get following results:

select dbtimezone, 
         sessiontimezone, 
         systimestamp, 
         current_timestamp 
from dual;

+00:00	
+02:00	
19.01.2010 13:28:30,288658000 +02:00	
19.01.2010 13:28:30,288664000 +02:00

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2010

Added on Jan 19 2010

4 comments

4,036 views