How do I retrieve the exact date/time from microsoft access in LabVIEW?

[iCat]

Microsoft access stores date/time in the precision up to a second.

It doesn't store milliseconds.

Thus, when I retrieve date/time from access and convert it to LabVIEW timestamp,

The variant "2012-04-16 14:45:01"(without millisecond) retrieved from access database becomes 2012-04-16 14:45:00.999 in LabVIEW timestamp.

I don't know how to append .000 to the retrieved variant.

How can I prevent LabVIEW from subtracting 1 millisecond from the access date/time variant while converting it to LabVIEW timestamp?

[RavensFan · Accepted solution]

Duplicate Post

Please don't create a new message with the same question.  Especially when you are already being helped in the other thread.