Database Administration (MOSC)

MOSC Banner

What should I set for flashback timestamp timezone property?

edited Oct 1, 2011 6:36PM in Database Administration (MOSC) 1 commentAnswered
 I need to run my database in Greek Time. We have already set the system clock to Greek Time. 
what should be the value for DBTIMEZONE and FLASHBACK TIMESTAMP TIMEZONE. 

We are only using DATE and TIMESTAMP data types. But,  we may need to use TIMESTAMP WITH  TIMEZONE datatypes. Currently, we are not enabling the FLASHBACK DATABASE option. But, we want to make sure that the timezones are properly setup so that we can use these features in future.

I would also like to understand whether I have to use the timezone name to take advantage of the day light saving.

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