NI Database Plugin, DateTime with fractional seconds on SQL Server

[Mr._Jim]

Hi folks,

I'm running SQL server, TestStand 2020 x64 and LabVIEW 2020 x64.

I've set up one of our model plugins to record UTC time for each step result, complete with fractional seconds. This works perfectly and I've got the full precision attached to each step result.

Using the NI Database plugin, I want to insert this value to a SQL Server column of type DateTime.

In the TestStand Database Options dialog, Schemas tab, I set my column to Date/Time with format string "yyyy-mm-dd hh:ii:ss.sss".

The value I'm inserting looks like "2021-03-20 00:05:55.717"

Here is the help page for the format strings

No matter what I try I cannot get the last .sss to go through. It always rounds to the nearest second. I'm verifying this through MSSMS.

I'm at wits end. I know it's a nitpicking thing but this really should work.

Has anyone done this successfully and / or what am I missing?

Thanks,

Mr. Jim