iNTERFACEWARE Products Manual > Learning Center > Chameleon Overview > Date Time Formats > How the Date Time Type is Implemented |
|
Looking for Iguana v.5 or v.6? Learn More or see the Help Center.
This Date Time type is implemented as a floating-point value, measuring days from midnight, 30 December 1899 in either direction. For example, midnight 31 December 1899 is represented by 1.0. Similarly, 6 AM, 1 January 1900 is represented by 2.25, and midnight, 29 December 1899 is -1.0. However, 6 AM, 29 December 1899 is -1.25. To interpret the time portion, take the absolute value of the fractional part of the number. Chameleon's date/time format can handle dates from 1 January 100 - 31 December 9999.
|