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
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:
- 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
- Postgres collation errors on CITEXT fields when upgrading to 9.1 21 May 2012
- Related by Text:
- jQuery and Highslide JS 08 January 2008
- I'm back! Peterbe.com has been renewed 05 June 2005
- Anti-McCain propaganda videos 12 August 2008
- Ever wondered how much $87 Billion is? 04 November 2003
- Guake, not Yakuake or Yeahconsole 23 January 2010
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;