Postgres Pro
Downloads
Home   >   mailing lists

Re: result of conversion to timestamp is shifted 1 minute back - Mailing list pgsql-bugs

From Thomas Lockhart
Subject Re: result of conversion to timestamp is shifted 1 minute back
Date
Msg-id 3AD45DD1.25939489@alumni.caltech.edu
Whole thread Raw
In response to result of conversion to timestamp is shifted 1 minute back  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
> When postgresql converts string representation of date to timestamp, he make one minute back error. Any insert or
updatewith 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

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: result of conversion to timestamp is shifted 1 minute back
Next
From: Thomas Lockhart
Date:
Subject: Re: reltime with NULL fields crashes backend