Home Forums SQL Server 2008 T-SQL (SS2K8) Time as a high precision difference of dates RE: Time as a high precision difference of dates
Lynn Pettis
SSC Guru
Points: 442467
More actions
September 4, 2012 at 1:03 pm
#1533473
Have you looked at DATETIME2 and TIME? They can go to 7 decimal places in precision and DATADIFF will go to nanoseconds if I remember correctly. Also, I think it only goes to 100 nanoseconds. You'll have to check that in Books Online.