THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008 » dates » time   (RSS)
Sorry, but there are no more tags available to filter with.
  • SQL Server 2008 Has Nanosecond Precision?

    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 ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on August 1, 2007
Privacy Statement