Reputation:
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
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