It looks like SQL Server 2008 has nanosecond precision for the time datatype [edit]I just looked at BOL and yes nanoseconds = ns, microsecond = mcs when used in dateadd[/edit] If you run the following DECLARE @t time SELECT @t = '0:0' SELECT @t AS Time1
Read More...