NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Database logging generated a time stamp in UUT_RESULT table. I am not sure how to interpretate the format of the time stamp.

I started logging my test results in Microsoft Access.
UUT_RESULT Table is generated as a result. There is a column named START_DATE_TIME with a double value such as 38146.5987731482. I am not sure how to interpretate this kind of time stamp format. I put this number into a LabView's built-in function SECONDS TO DATA/TIME and it didn't return the current date. Does anyone know how to interpretate this time stamp?
0 Kudos
Message 1 of 3
(2,975 Views)
LegalEngineer -
TestStand by default logs dates to a database column of type DATETIME. Most databases store dates as double values. If you retrieve the column value as a Variant, the variant type will be VT_DATE. I would think the Variant To Data.vi will allow you to extract the date into a string.

OLEAUTO32.DLL has a function called VarBstrFromDate() which allows you to format Variants low level.

Scott Richardson (NI)
Scott Richardson
https://testeract.com
0 Kudos
Message 2 of 3
(2,975 Views)
It is days since Jan. 1st, 1900 with the time represented as the fractional part of the number. Oracle stores the number this way (or at least returns that representation), but I'm not sure about other databases. Different operating systems have their own representation, such as days since Jan. 1, 1970, which probably why you are not getting the right date back.
0 Kudos
Message 3 of 3
(2,975 Views)