Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres UTC different from perl? - Mailing list pgsql-general

From Tom Lane
Subject Re: postgres UTC different from perl?
Date
Msg-id 14043.1198437927@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres UTC different from perl?  (Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org>)
List pgsql-general
Tree view 
Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org> writes:
> On Wed, Dec 19, 2007 at 08:14:17PM -0500, Tom Lane wrote:
>> Richard Huxton <dev@archonet.com> writes:
>>> I'm not sure that (CURRENT_DATE AT TIME ZONE 'UTC') does what you think
>>> it does. Try setting your timezone to various offsets and exploring.

> Does that mean it's a postgresql bug?

No.

            regards, tom lane

pgsql-general by date:

Previous
From: "Trevor Talbot"
Date:
Subject: Re: pgsql cannot read utf8 files moved from windows correctly!
Next
From: Tom Lane
Date:
Subject: Re: Constraint Trigger's referenced_table