Report query does not work in MSSQL

Report query does not work in MSSQL

The query provided to show time spent in http://forums.manageengine.com/topic/query-to-get-the-timespent-on-the-requests-which-are-open#49000005169121

I can't get it working in MSSQL - longtodate is not a supported function.

Can you please provide a working version of this query?

Many thanks,

Dean