Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

DVD Date Difference Calculation

Received Response
31
Views
2
Comments
Brian666H
Brian666H Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

Summary

DVD Date Difference Calculation

Content

New Calculation

(sysdates - entered_dt)

I get an error .  Invalid expression

I need to find the days difference.

Answers

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    TIMESTAMPDIFF

    TIMESTAMPDIFF(SQL_TSI_DAY, tstmp1, tstmp2)

  • Pathak Sonkar
    Pathak Sonkar Rank 3 - Community Apprentice

    Another way will be to use CAST AS DATE and the CURRENT_DATE column given by DVD as below:

    image

    This will give you date differences.

    hope this helps...