Oracle DV Desktop - How to get days difference between 2 date columns
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)