Re: Daylight Savings Time....

From: Dave <solomons_dad.w.marks_and_whom_at_oracle.com>
Date: Thu, 03 Nov 2005 11:12:33 +0000
Message-ID: <Ovmaf.5$713.105@news.oracle.com>

Miggins wrote:
> Hi,
>
> Am wanting to know what value to set the Database time zone to so that
> it will add on or take off the one hour between GMT and BST.
>
> Will the software add on or take off the hour automatically when times
> switch from British Summer Time and GMT?
>
> Thanks
>

In 10g there's a whole stack of timezone related features - you can store timestamps with or without time zones, and with or without conversion - lookup TIMESTAMP [WITH [LOCAL] TIME ZONE] in Chapter 2 of the SQL Reference.

Storing timestamps "with local time zone" will convert the data on retrieval to the client's time zone; you can store 9am BST, and someone in Germany will retrieve this as 10am CET. Received on Thu Nov 03 2005 - 05:12:33 CST