0 
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
Improve this question

1 Answer 1

Reset to default
1 
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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.