DateTime Type

A string that represents a date and time in a subset of the ISO 8601 format.

Remarks

The date and time string is in the following format:

yyyy-MM-ddTHH:mm:ss.fff

Where each component has the following meaning:

Component	Description
yyyy	The year as a four-digit number.
MM	The month, from 01 through 12.
dd	The day of the month, from 01 through 31.
HH	The hour, using a 24-hour clock from 00 to 23.
mm	The minute, from 00 through 59.
ss	The second, from 00 through 59.
fff	The milliseconds, from 000 through 999.

Component

Description

yyyy

The year as a four-digit number.

The month, from 01 through 12.

The day of the month, from 01 through 31.

The hour, using a 24-hour clock from 00 to 23.

The minute, from 00 through 59.

The second, from 00 through 59.

fff

The milliseconds, from 000 through 999.

The time components may be omitted if hour, minute, second and millisecond are zero (midnight):

yyyy-MM-dd

"2000-01-01T00:00:00.000"

"2000-01-01"

2000-01-01T00:00:00.000

2000-01-01