|
|
|
|
Browse by Tags
All Tags » Time » SQL Server 2008 (RSS)
-
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,DATEADD(ms,1,@t) AS TimeMilli,
DATEADD(ns,10000,@t) AS TimeNano1,DATEADD(ns,100,@t) AS ...
|
|
|
|
|