Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 279 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
DVD Date Difference Calculation
Brian666H
Rank 6 - Analytics & AI Lead
Summary
DVD Date Difference Calculation
Content
New Calculation
(sysdates - entered_dt)
I get an error . Invalid expression
I need to find the days difference.
0
Answers
-
TIMESTAMPDIFF
TIMESTAMPDIFF(SQL_TSI_DAY, tstmp1, tstmp2)
0 -
Another way will be to use CAST AS DATE and the CURRENT_DATE column given by DVD as below:
This will give you date differences.
hope this helps...
0