E.2. TIME
One of the limitations of the old DATETIME data type (which is still available) is the precision of the time component. Accurate to .333 second, the DATETIME type lacked granularity for certain applications, an issue addressed by the TIME type.
In addition to supporting the ability to store just the time component (without a corresponding date), the TIME data type, consuming between 3 and 5 bytes, is accurate to 100 nanoseconds and permits the storage of time values from 00:00:00.0000000 through 23:59:59:9999999.
Get SQL Server 2008 Administration in Action now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
