Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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