Message-
From: Steve Crawford [mailto:scrawf...@pinpointresearch.com]
Sent: Friday, March 18, 2011 1:05 PM
To: jonathansfl
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] TO_CHAR(timestamptz,datetimeformat) wrong after DST
change
On 03/18/2011 07:59 AM, jonathansfl wrote:
> My TO_
On 03/18/2011 07:59 AM, jonathansfl wrote:
My TO_CHAR function is now an hour off thanks to Daylight Savings Time.
The dates are correct (I'm in EST: TZ=-04) but my function now returns TIME
an hour early.
(prior to DST we were TZ=-05).
TIMESTAMPTZ data (v_dt): 2011-03-17 18:21:50-04
FUNCTION SN
My TO_CHAR function is now an hour off thanks to Daylight Savings Time.
The dates are correct (I'm in EST: TZ=-04) but my function now returns TIME
an hour early.
(prior to DST we were TZ=-05).
TIMESTAMPTZ data (v_dt): 2011-03-17 18:21:50-04
FUNCTION SNIPPET: to_char(v_dt, 'mm/dd/ hh:mi AM')
