Return
-
Title
Running query with DateTime data type does not display milliseconds data in Results tab. -
Description
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.
-
Resolution
WORKAROUND:
NoneSTATUS:Waiting for fix to be released in a future version of Toad for SQL Server. -
Defect ID
CR 91106