Tag Archives: TIMESTAMP WITH LOCAL TIME ZONE

Oracle Database Time Zone

1) dbtimezone only shows the database creation time TZ offset from OS environment. For AEST, it could be either of the below depending on OS environment variable: 00:00 +10:00 ( non DST ) +11:00 ( DST ) SQL> select dbtimezone … Continue reading

Posted in Configuration, Globalization | Tagged , , , , , , , , , , , , | Leave a comment