Adding a year in PostgreSQL

04 February 2004   1 comment   Linux

http://www.postgresql.org/docs/7.4/static/functions-datetime.html#OPERATORS-DATETIME-TABLE

Mind That Age!

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.

Comments

Peter

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;

Your email will never ever be published


Related posts

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