From: | "Timofey(dot)Asyrkin" <timoha-tim(at)ngs(dot)ru> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4757: to_timestamp returns incorrect result |
Date: | 2009-04-11 19:06:05 |
Message-ID: | 200904111906.n3BJ65G2072403@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4757
Logged by: Timofey.Asyrkin
Email address: timoha-tim(at)ngs(dot)ru
PostgreSQL version: 8.3
Operating system: Ubuntu 8.10
Description: to_timestamp returns incorrect result
Details:
Hello everybody,
It looks like there is a bug in to_timestamp function:
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
Having executed with different date, but the same time didn't gave such
result, moreover, changing the timezone gives correct result.
Kind regards,
Timofey
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2009-04-11 20:14:40 | Re: libpq 8.4 beta1: $PGHOST complains about missing root.crt |
Previous Message | tushar | 2009-04-11 15:12:08 | Re: BUG #4756: Installationproblems |