CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Calculations using both date and date/time fields

edited Jun 14, 2013 4:17AM in CRM On Demand - Reports and Dashboards (MOSC) 7 commentsAnswered ✓
I have two fields, lets call them Field-1 which is a Date type and Field-2 which is a Date/Time type.  I need to calculate the difference between these two fields in hours or fractions of days.  However, the Date field doesn't have time.  It is fine if the solution involves Field-1 defaulting to midnight.  I tried simply subtracting Field-1 from Field-2 but that doesn't work.  Tried using the CAST function to CAST Field-1 as a TIMESTAMP.  That doesn't work.  Tried using the TIMESTAMPDIFF function which doesn't work because they aren't both Date/Time fields.  Does anyone have a set of conversions and/or

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center