Re: Bug #897: EXTRACT(EPOCH FROM column): Possible wrong output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jonas(at)understroem(dot)dk
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #897: EXTRACT(EPOCH FROM column): Possible wrong output
Date: 2003-02-27 21:39:35
Message-ID: 29470.1046381975@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I said:
> In most other contexts, we interpret such values as being in local time
> (the current server TimeZone) when it's necessary to make a distinction.
> Consistency would suggest doing it that way here too, I think.

I have applied a patch to make extract(epoch from timestamp) assume that
timestamps without time zone are in local time, and generate the correct
Unix epoch value accordingly. This will appear in 7.3.3.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Herrmann, DP ITS, SMN, DD 2003-02-28 07:42:59 Installation problem under Windows NT 4 german version
Previous Message Hubert depesz Lubaczewski 2003-02-27 17:58:54 Re: psql -F problems