Forum OpenACS Q&A: Response to date_add, returns "wrong" dates

Collapse
2: Response to date_add, returns "wrong" dates (response to 1)
Posted by Jonathan Ellis on 03/15/02 04:38 PM
what version of PG are you using?  works fine for me in 7.1.3.

try it without the date_add wrapper --
select '1999-12-31'::date + '1 years'::interval;

(and yes, 12-31 + 1 month = 1-31 not 1-30)