|
|
|
|
Browse by Tags
All Tags » SQL Server 2008 » dates (RSS)
-
I was reading Itzik Ben-Gan's An Introduction to New T-SQL Programmability Features in SQL Server 2008 article yesterday after one of my friends allerted me to the following from that articleFor example, the plan for the following query performs an index seek on the index on the CurrencyRateDate DATETIME column:
USE AdventureWorks;
SELECT ...
-
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 ...
|
|
|
|
|