Date, Time and DateTime are stored in ISO 8601 format.
The formats are as follows. The components and punctuation should be exactly as shown.
Date
YYYY-MM-DD (eg 2013-07-16)
Time
hh:mm:ss.s (eg 14:10:20.45)
DateTime
YYYY-MM-DDThh:mm:ss.sTZD (eg 2013-07-16T14:10:20.45+02:00)The notation followed is -
- 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)
- mm = two digits of minute (00 through 59)
- ss = two digits of second (00 through 59)
- s = one or more digits representing a decimal fraction of a second
- TZD = time zone designator (Z or +hh:mm or -hh:mm)