Horton
Menu

Re: result of conversion to timestamp is shifted 1 minute back

Thomas Lockhart <lockhart@alumni.caltech.edu>

View thread
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: tdobrovolny@certifis.cz, pgsql-bugs@postgresql.org
Date: 2001-04-11T13:36:17Z
Lists: pgsql-bugs 
> When postgresql converts string representation of date to timestamp, he make one minute back error. Any insert or update with string date representation damage real value of date!
> BUT if you use string date representation without time part, your data will be shifted one day back!!!
> Tested on RedHat 7.0, PostgreSQL 7.0.3

We will need more details on your installation to be able to help, since
this is *not* reproducible on most systems. We've never heard of this
before!

                      - Thomas