"Timofey.Asyrkin" <timoha-...@ngs.ru> writes:
> I'm living in Italy and I have a timezone GMT+2 (summer).
> These two queries return the same result:
> 1)select TO_TIMESTAMP( '25/03/2001 02:00:00', 'dd/mm/yyyy hh24:mi:ss' );
> 2)select TO_TIMESTAMP( '25/03/2001 03:00:00', 'dd/mm/yyyy hh24:mi:ss' );
> Result: 2001-03-25 03:00:00+02
If that day is a DST transition day, those results are not wrong.
The two times are the same, and it happens that we preferentially
show that time in DST.
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
