BI Query to get Difference between Dates in numeric format
SummaryWe 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.