You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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!

Oracle DV Desktop - How to get days difference between 2 date columns

Accepted answer
28
Views
7
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics 7 comments

Content

Hi, Wondering if anyone can assist.

I have 2 columns with dates in them but I can't calculate the difference of days between them in a new column.  I have tried a number of function and playing around with getting it right, but can't crack it.  I have tried the below but while it validates ok it doesn't return the days.

CURRENT_DATE - CAST( Actual Date as TIMESTAMP)

I have also tried using: TIMESTAMPDIFF(interval, first_date, second_date)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!