iNTERFACEWARE™ Inc.

How the Date Time Type is Implemented

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.

	Null Values If a null value is passed in as a Date Time, it will be converted to 30 December 1899, since that is represented as 0.0.