This blog post is 15 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
SELECT
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.
- Previous:
- PayPalSucks.com, can't be good for PayPal 04 February 2004
- Next:
- Techie things I want to buy from ebuyer.com 05 February 2004
- Related by Keyword:
- How I performance test PostgreSQL locally on macOS 10 December 2018
-
Best EXPLAIN ANALYZE benchmark script 19 April 2018
- When Docker is too slow, use your host 11 January 2018
- How do log ALL PostgreSQL SQL happening 20 July 2015
- Fastest database for Tornado 09 October 2013
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;