TO_CHAR(timestamptz,datetimeformat) wrong after DST change

Поиск
Список
Период
Сортировка
От jonathansfl
Тема TO_CHAR(timestamptz,datetimeformat) wrong after DST change
Дата
Msg-id 1300460341680-3966319.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: TO_CHAR(timestamptz,datetimeformat) wrong after DST change
Список pgsql-general
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/yyyy hh:mi AM')
FUNCTION RETURNS: 03/18/2011 09:21 AM
FUNCTION SHOULD RETURN: 03/18/2011 10:21 AM

postgres=# show time zone;
     TimeZone
------------------
 America/New_York
(1 row)



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/TO-CHAR-timestamptz-datetimeformat-wrong-after-DST-change-tp3966319p3966319.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

В списке pgsql-general по дате отправления: