04 February 2004
This blog post is
16 years old! Most likely, its content is outdated.
Especially if it's technical.
Finally I found it. How to add one year to a date in PostgreSQL
date('now') + interval '1 year' AS today_in_one_year,
date '2003-12-13' + interval '1 year' AS my_next_birthday ;
Both return a TIMESTAMP type.
Follow @peterbe on Twitter
UPDATE: It doesn't return a TIMESTAMP type, it's a DATE type (only 4 bytes).To get a TIMESTAMP you can do this:SELECT '2003-12-13' + interval '1 year' AS my_next_birthday;
Your email will never ever be published
© peterbe.com 2003 - 2020
Hosted on Digital Ocean
Check out my side project