Support Board

Date/Time: Thu, 25 Apr 2024 18:01:27 +0000

Post From: Storing SCDateTime-data in a subgraph array?

[2020-11-25 22:13:53] Link To Thread - Link To Post [Go To First Post]
kraut - Posts: 20
To answer my own question: I just found out that the double floating point representation is the same as in Excel. Therefore, the resolution of a date time value down-casted to float should have a precision up to an hour (100 years * 365 days * 24 hours = 876,000, i.e. 6 digits, which should be stored near full precision in a float variable). Minutes, however would not be guaranteed to be represented correctly. The float range is 3.4E +/- 38 (7 digits).