Date/Time: Sun, 04 Jun 2023 16:28:59 +0000
Post From: Storing SCDateTime-data in a subgraph array?
|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).