Support Board
Date/Time: Fri, 06 Dec 2024 00:48:54 +0000
Post From: Storing SCDateTime-data in a subgraph array?
[2020-11-25 22:13:53] |
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). |