Re: TO_TIMESTAMP_TZ and unix timestamps

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 27 Jan 2005 08:51:27 +0100
Message-ID: <9a7hv0dh0up2hsg6derd0q6bnfvpqtqrdj@4ax.com>

On Wed, 26 Jan 2005 10:19:18 -0800, DA Morgan <damorgan_at_x.washington.edu> wrote:

>The problem with trying to take into account daylight savings time
>is that it doesn't actually exist. Well it may where you live. But
>it doesn't in many countries, in some states, and even in some parts
>of some states. How's the poor CPU to know?
>
>I think you'll have to write this one yourself using local rules.
>--

No, you can set DST in the TZ variable.
If the Unix time is incorrect it means the sysadmin has an incorrect TZ variable set.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Jan 27 2005 - 01:51:27 CST