Skip site navigation (1) Skip section navigation (2)

result of conversion to timestamp is shifted 1 minute back

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: result of conversion to timestamp is shifted 1 minute back
Date: 2001-04-11 13:14:22
Message-ID: 200104111314.f3BDEMf38121@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Tomas Dobrovolny (tdobrovolny(at)certifis(dot)cz) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
result of conversion to timestamp is shifted 1 minute back

Long Description
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

Sample Code
select timestamp('2001-12-25 23:59:00+01') ;
gives 2001-12-25 23:58:00+01

select timestamp('2001-12-25 11:10:00+01') ;
gives 2001-12-25 11:09:00+01

select timestamp('2001-12-25') ;
gives 2001-12-24 23:59:00+01

No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Thomas LockhartDate: 2001-04-11 13:36:17
Subject: Re: result of conversion to timestamp is shifted 1 minute back
Previous:From: pgsql-bugsDate: 2001-04-11 11:38:04
Subject: reltime with NULL fields crashes backend

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group