Login Page - Create Account

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).