Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Problem with adding days in a date(sql)
Summary
Problem with adding days in a date (sql)Content
Hi All,
I’m building a bi report and I have the following problem when building the data model.
Oracle provides ADD_MONTHS() function to use when adding duration to a date the function takes two parameters:
- Date
- Integer
i.e. ADD_MONTHS(28- Feb-2017,5)
More over if you directly add a number to a date like (‘23 - Mar – 2017’)+ 40 this is automatically taken as adding 40 days to that date.
What can I do if the duration I want to add is in a decimal value e.g. 8.9 months because the ADD_MONTHS() function fail in this case?
1