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

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: tdobrovolny(at)certifis(dot)cz, pgsql-bugs(at)postgresql(dot)org
Subject: Re: result of conversion to timestamp is shifted 1 minute back
Date: 2001-04-11 13:36:17
Message-ID: 3AD45DD1.25939489@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Lockhart 2001-04-11 13:44:34 Re: reltime with NULL fields crashes backend
Previous Message pgsql-bugs 2001-04-11 13:14:22 result of conversion to timestamp is shifted 1 minute back