SQL Language (MOSC)

MOSC Banner

systimestamp

edited Mar 12, 2012 1:07PM in SQL Language (MOSC) 3 commentsAnswered ✓
Hi,
If my dbtimezone is set to +00:00 and my sessiontimezone is also +00:00 why systimestamp returns CST time zone? It should return greenich time instead?

SQL> ALTER SESSION SET time_zone='-00:00';

Session altered.

SQL> select systimestamp from dual;

SYSTIMESTAMP
---------------------------------------------------------------------------
12-MAR-12 03.48.29.684000 PM -05:00

SQL> SELECT dbtimezone,sessiontimezone FROM dual;

DBTIME
------
SESSIONTIMEZONE
---------------------------------------------------------------------------
+00:00
+00:00

Confused.

Thanks,
Sha


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center