Running query with DateTime data type does not display milliseconds data in Results tab.
Declare
@Test_DateTime1 as datetime
, @Test_DateTime2 as datetime2(7)
, @Test_DateTime3 as datetime2(7)
set @Test_DateTime1 = getdate()
set @Test_DateTime2 = getdate()
set @Test_DateTime3 = SYSUTCDATETIME()
select @Test_DateTime1 as '@Test_DateTime' , @Test_DateTime2 as '@Test_DateTime2' ,@Test_DateTime3 as '@Test_DateTime3'
Same query shows milliseconds in Management Studios.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center