SQL Server: DATEDIFF limitations
Posted by Em on 2 September, 2008
No comments yet
This item was filled under [ SQL Server ]
DATEDIFF produces an error if the result is out of range for integer values. For milliseconds, the maximum number is 24 days, 20 hours, 31 minutes and 23.647 seconds. For seconds, the maximum number is 68 years.
Source: Transact-SQL Reference
Rate this topic:
(No Ratings Yet)
Loading ...
(No Ratings Yet) Loading ...Popularity: 87 views
