Sql Server Diff Datetime. See the valid date parts in the table below. However the datetime value continues to be rounded up.
Now the difference is correct but the date portion contains the date where sql server starts to calculate date values. Definition and usage the datediff function returns the difference between two dates. The initial date is 1900 01 01 so in order to get the correct results we need to subtract corresponding years months and minutes.
It works on any expression that can be resolved to a time date smalldatetime datetime datetime2 or datetimeoffset value.
In sql server you can use the t sql datediff function to return the difference between two dates times. Sql server datediff function returns the difference in seconds minutes hours days weeks. Datepart the units in which datediff reports the difference between the startdate and. This article provides examples of the datediff function in sql server.
