Note : public note
Created: 5/8/2008 3:52:19 PM
Modified: 5/8/2008 3:52:22 PM
Project:
Advanced:
Date/time in ISO 8601 variable length character form:
YYYY-MM-DDThh:mm:ss.fffffffff
example 2006-05-31T14:30:33.123

where:
YYYY = four-digit year
MM = two-digit month (01=January, etc.)
DD = two-digit day of month (01 through 31)
hh = two digits of hour (00 through 23)
(am/pm NOT allowed)
T = literal "T" character
mm = two digits of minute (00 through 59)
ss = two digits of second (00 through 59)
fffffffff = represents a decimal fraction of a second
to the billionth of a second

Year, month, and day must be specified. Additional timestamp
content should be provided, if known. Zeros will be assumed for
the omitted values. Negative DATETIME is not supported. All
suffixes after the 29th character provided in the ISO 8601
specification, such as "Z" (representing Coordinated Universal
Time (UTC), are not necessary since the CRIS specification
explicitly manages local offset hours and minutes as distinct
columns associated with the UTC (referred to in the CRIS
specification prefixed with "GMT") column.

Note that the actual difference between the new
DATETIME(10:29) data type and the CRIS V2.1 fixed-length
STRING(29) form is the separator between date and time
information is now a literal "T" instead of a blank space, the
separator for the billionths of seconds is now a dot (".")
instead of a dash ("-"), and trailing items after the
year-month-day fields may be omitted.