TSQL DateDiff to return number of days with 2 decimal places September 8, 2023 by Tarik Take the DateDiff in seconds instead, and then divide by 86400.0. The decimal point is required.