Re: extract epoch bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: olav(at)venus(dot)jordforsk(dot)no (Hans Olav Eggestad)
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: extract epoch bug
Date: 2005-07-05 15:04:15
Message-ID: 13219.1120575855@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

olav(at)venus(dot)jordforsk(dot)no (Hans Olav Eggestad) writes:
> I've just installed v8.0.3 and tested the 'epoch' part of extract, which for
> my applications is fundamental. here is the result:
> [ snip ]

Nothing wrong with that that I can see. If you want a date to be
interpreted as midnight GMT rather than midnight your local zone,
either say so or set TimeZone to GMT.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thanh Q Lam 2005-07-05 15:16:45 Error installing Postgres on Solaris 9
Previous Message Achilleus Mantzios 2005-07-05 14:30:14 Re: extract epoch bug