CODEWITHSUNDEEP
sqloracle-databasedate
Cheryl
Cheryl

Reputation: 231

Oracle: How to add 6 months to current date

In SQL Server I can do this to add 6 months to the current date:

DateAdd(Month, 6, CURRENT_DATE)

What is the equivalent in Oracle?

Upvotes: 23

Views: 64734

Answers (1)

Steve Mayne
Steve Mayne

Reputation: 22818

The equivalent is:

ADD_MONTHS( CURRENT_DATE, 6 )

Upvotes: 45

Related Questions