Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 06:22:37 +0000



Post From: Intraday Record format after the SCDate time Changes

[2021-04-17 16:17:45]
User681150 - Posts: 62
when i unpack the record, it shows the datetime as 1.891136406826626e-308

the help doc says this is the 'This is a 64-bit integer. It represents the number of microseconds since the SCDateTime epoch of December 30, 1899."

in order to convert microseconds to a date&time, it needs to be 16 digits long

but how do i convert this value into a 16 digit microsecond equivalent?

i am using dataRow = struct.unpack('d4f4I', record), is the formatting ('d4fdI') wrong?

thanks for any help getting this into a 16 digit microsecond