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

BI Query to get Difference between Dates in numeric format

Accepted answer
edited Apr 7, 2020 7:09AM in Reporting and Analytics for ERP 3 comments


We have requirement to get the Average time required to complete particular ESS Job in Minutes or Seconds.


Here are more details - 

We need to calculate the difference between REQUEST_HISTORY.PROCESSEND - REQUEST_HISTORY.PROCESSSTART columns and the value returned by the above date difference should be in number format to use AVG function in query further. 

But for the below simple query the difference we are getting between dates is not in number format and it is in some date time format which can not be used for further calculation.Can anyone help with any function or format conversion to get the difference between dates in numeric format.

Howdy, Stranger!

Log In

To view full details, sign in.


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