SQLTeam.com | Weblogs | Forums

How to add a year to the date in Oracle SQL?

How to add a year to the date in Oracle SQL?

SQLTeam is a Microsoft SQL Server site, we're not experts in Oracle.

It seems that you can accomplish what you're looking for using CURRENT_DATE and INTERVAL expressions, see here for some more detail:

https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm#sthref371