Previous page

Next page

Locate page in Contents

Print this page

datetime_type

Summary:

Holds a datetime value.

Type specification:

datetime_type is derived from string

The type complies with ISO-8601, the International Standard for the representation of dates and times. The format is as follows.

YYYY-MM-DDThh:mm:ssZ

where:

YYYY -- four-digit year.

MM -- two-digit month (01 = January, etc.).

DD -- two-digit day of month (01 through 31).

The letter T in DDThh must literally be present to indicate the beginning of the time element.

hh -- two digits of hour (00 through 23, am/pm is NOT allowed).

mm -- two digits of minute (00 through 59).

ss -- two digits of second (00 through 59).

Z -- GMT/UTC offset (+hhmm or -hhmm).

Example:

2006-05-28T19:05:30-0500 corresponds to May 28, 2006, 19:05:30 (or 7:05:30 pm), US Eastern Standard Time.

Please send us your feedback on this help page