Re: postgres UTC different from perl?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Louis-David Mitterrand <vindex+lists-pgsql-general(at)apartia(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres UTC different from perl?
Date: 2007-12-23 19:25:27
Message-ID: 14043.1198437927@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Louis-David Mitterrand <vindex+lists-pgsql-general(at)apartia(dot)org> writes:
> On Wed, Dec 19, 2007 at 08:14:17PM -0500, Tom Lane wrote:
>> Richard Huxton <dev(at)archonet(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Trevor Talbot 2007-12-23 22:07:44 Re: pgsql cannot read utf8 files moved from windows correctly!
Previous Message Tom Lane 2007-12-23 19:20:24 Re: Constraint Trigger's referenced_table