Strange results with interval types computations

Started by PostgreSQL Bugs Listabout 25 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

Laurent HERVE (laurent_herve@infonie.fr) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Strange results with interval types computations

Long Description
Look at those two queries :

ez_money=> select '10/01/2000'::date+'1 month'::interval;
?column?
----------------------
2000-10-31 23:00:00+01
(1 row)

ez_money=> select '09/01/2000'::date+'1 month'::interval;
?column?
----------------------
2000-10-01 00:00:00+02
(1 row)

Strange that 10/01/2000 + 1 month does not give 11/01/2000 !

Sample Code

No file was uploaded with this report

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: Strange results with interval types computations

pgsql-bugs@postgresql.org writes:

ez_money=> select '10/01/2000'::date+'1 month'::interval;
?column?
----------------------
2000-10-31 23:00:00+01
(1 row)

DST transition problem. It's fixed in current sources.

regards, tom lane