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:
- 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
- Connecting with psycopg2 without a username and password
24 February 2011
- Related by Text:
- Be very careful with your add_header in Nginx! You might make your site insecure
11 February 2018
- 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
To get a TIMESTAMP you can do this:
SELECT '2003-12-13' + interval '1 year' AS my_next_birthday;