hfuxel...@gmail.com writes: > test to run: select to_timestamp('2011,03,27,02,11,11', > 'YYYY,MM,DD,HH24,MI,SS')
> and the run: select to_timestamp('2011,03,27,03,11,11', > 'YYYY,MM,DD,HH24,MI,SS') > It miscalculates 02 hour to 03 hour by some reason If that date is a DST forward transition date in your timezone, then this behavior is neither surprising nor a bug. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs