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
- I'm Prolog
01 May 2007
- Ever wondered how much $87 Billion is?
04 November 2003
To get a TIMESTAMP you can do this:
SELECT '2003-12-13' + interval '1 year' AS my_next_birthday;