user3422859
user3422859

Reputation:

Adding a year in PostgreSQL

select current_date

Will return

Date
----
2014-10-16

so is there any function or way to get the same day and month with next year, I.e

next_year_date
----
2015-10-16

Upvotes: 0

Views: 49

Answers (1)

Vivek S.
Vivek S.

Reputation: 21895

select 
(current_date + interval  '1 year')::date next_year_date

Or

select 
date (now()::date + interval '1 year') next_year_date

Date/Time Functions and Operators

Upvotes: 1

Related Questions