Database Administration (MOSC)

MOSC Banner

LocalTimestamp value difference

edited Mar 28, 2013 3:28AM in Database Administration (MOSC) 6 commentsAnswered
Can someone explain me the difference in LOCALTIMESTAMP value when time_zone is set to DBTIMEZONE and LOCAL respectively.

alter session set time_zone =DBTIMEZONE;

SELECT systimestamp,DBTIMEZONE,localtimestamp FROM DUAL;

##############################################

 SYSTIMESTAMP                        DBTIME LOCALTIMESTAMP                

----------------------------------- ------ -------------------------------

28-FEB-13 08.14.03.445364 AM -05:00 -04:00 28-FEB-13 09.14.03.445374 AM

 ####################################################################################

 alter session set time_zone =LOCAL;

 ##############################################

 SELECT systimestamp,DBTIMEZONE,localtimestamp FROM DUAL;

 SYSTIMESTAMP                        DBTIME LOCALTIMESTAMP                

----------------------------------- ------ -------------------------------

28-FEB-13 08.14.05.314946 AM -05:00 -04:00 28-FEB-13 08.14.05.314957 AM

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