question

Ellie Ryder avatar image
Ellie Ryder asked

How do you find out which time zone a database is operating under?

Is there a way to find out under which time zone a database is operating?

time
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Tariq Rahiman avatar image
Tariq Rahiman answered

I found this in Oracle documentation. The link is Finding Local Timezone for Oracle 8i

This is for another link with all the basic information regarding Timezone

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Christian13467 avatar image
Christian13467 answered

DBTIMEZONE returns the timezone under which the database is operating.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions039.htm#i1327612

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.