Re: Which time-zone for Germany?

From: <Kenneth>
Date: Thu, 22 Apr 2004 16:18:59 GMT
Message-ID: <4087ede0.2885368@news.inet.tele.dk>

On 22 Apr 2004 08:56:46 -0700, cha_at_christian-hartmann.de (Christian Hartmann) wrote:

>Hi there,
>
>today I want to set up (create) a database using the clause
>
>set time_zone
>
>The funny question is which time zone I should mention for Germany. Is
>there anybody who can help?
>
>Regards,
>
>Christian

Hi Christian,

If you do not specify time_zone, Oracle chooses the time zone of the server on which it resides. Which is probably a good thing. And the right choice in 99,5% of the cases.

If you really want to set it manually, it's either (UTC notation)

create database foo

...
......
.....

set time_zone = '+01:00';

or (using time zone names)

create database foo

...
......
.....

set time_zone = 'CET';

• Kenneth Koenraadt

Received on Thu Apr 22 2004 - 11:18:59 CDT