04 February 2004
This blog post is
14 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
Your email will never ever be published
© peterbe.com 2003 - 2018
Hosted on Digital Ocean
Check out my latest side project