We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
31
Views
3
Comments
edited Apr 7, 2020 7:09AM in Reporting and Analytics for ERP 3 comments

Summary

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

Content

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.

Register

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