sql - TSQL DateDiff to return number of days with 2 decimal places

Question

I need to compare 2 dates and return the number of days in between with 2 decimal places.

For example:

when comparing

SubmittedDate = 2012-02-29 07:02:55.000

FirstCall = 2012-02-29 12:12:19.000

That is a 5 hour difference. So I would return 0.2 days

I have tried:

CAST(DATEDIFF(Hour, SubmittedDate, FirstCall)/30.0 AS DECIMAL(5,2)) As HoursBeforeFirstCall
CAST(DATEDIFF(Day, SubmittedDate, FirstCall) AS DECIMAL(5,2)) As HoursBeforeFirstCall

None seem to work.

Answer 1

Take the DateDiff in seconds instead, and then divide by 86400.0. The decimal point is required.