Re: Daylight saving in Oracle 10g

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 02 Dec 2005 08:59:15 +0100
Message-ID: <fkvvo1576keeueo0b8fm717sov1dh8can1@4ax.com>

On Fri, 02 Dec 2005 07:52:42 +0100, Geld Marcoss <geld1_at_nexus.hu> wrote:

>Hello,
>
>how is it possible with Oracle 10g to get whether the actual sysdate is
>in summer or in winter time?
>
>Does anybody know about a good description regarding Oracle10g and the
>daylight saving technics?
>
>Thanks!

There aren't any, as Oracle takes the time and date from the system clock. Also: if you really need to deal with timezones etc, you'll need the TIMESTAMP datatype, not DATE

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Dec 02 2005 - 01:59:15 CST