Mapping Time, TimeStamp, and Date Primitive Types to the SQL Server DATETIME Type

SQL Server has separate date and time data types. Valid dates are in the range 0001-01-01 through 9999-12-31.

In Date primitive types, the initial value of zero (0) is not valid and can be distinguished from a valid (or set) value or an invalid date (set by user code).

In Time primitive types, the initial value of zero (0) is a valid time of 00:00:00 and cannot be distinguished from a set value. An invalid time can be set by user code.

The following table defines the available mappings of JADE types to SQL Server DATE and TIME data types.

JADE Primitive Type	JADE Value	SQL Server DATE and TIME Data Types
Date	Valid SQL Server Date	ValidDate
	Invalid SQL Server Date	Null column with message to log (SQL Server date limits)
Time	ValidTime (including 0)	ValidTime