I am trying to extract a timestamp from my database in MS SQL and I am not getting the milliseconds when I fetch the data. Does anyone know how to program sql or labview so I can get the whole timestamp. In SQL I have it set as datetime2. I'll appreciate any help. Thanks
Solved! Go to Solution.
Have you confirmed the ms data is in the database? If so, how exactly are you converting the SQL response to LabVIEW data? If you are using the variant to data and supplying it with a LabVIEW timestamp, try changing it to a string and verify the data is in the response (you may also be able to probe the variant and see it). I have had issues with NI's conversions of SQL timestamps into LV timestamps, particularly with bit errors so the timestamp no longer matches the timestamp in the database. I have had to bring it in as a string, then use Scan From String to convert it into a timestamp reliably.
It looks like it is an ADO driver issue, not specific to LabVIEW. If you use the query
SELECT Convert(varchar,Start_Test_Time,21) FROM Engine_Tests
you can get the data back in a string and convert to a timestamp.
You can also use
SELECT DATEPART(msStart_Test_Time) FROM Engine_Tests
to just get the ms part. More info on DATEPART can be found here: