Reads complete, truncated, and omitted forms of ISO 8601 duration, datetime, and interval values that are specified in either the basic or extended notations.
| Categories: | Date and Time |
| ISO 8601 | |
| Alignment: | Left |
| Restriction: | UTC time zone offset values are not supported. |
| Supports: | ISO 8601 Element 5.4.4, complete representation |
specifies the width of the input field.
| Default | 50 |
| Range | 1–200 |
| Requirement | The minimum length for a duration value or a datetime value is 16. The minimum length for an interval value is 16. |
specifies the number of digits to the right of the decimal point in the seconds value. This argument is optional.
| Default | 0 |
| Range | 0–3 |
|
Time Component
|
ISO 8601 Notation
|
Example
|
|---|---|---|
|
Duration
|
Pyyyy-mm-ddThh:mm:ss.fff
|
P2012-09-15T15:53:00
|
|
|
PyyyymmddThhmmss
|
P00020304T050607
|
|
|
PnYnMnDTnHnMn.fffS
|
P2y10m14dT20h13m45.222s
|
|
|
PnW
|
P6w
|
|
Interval
|
yyyy-mm-ddThh:mm:ss.fff/yyyy-mm-ddThh:mm:ss.fff
|
2012-09-15T15:53:00/2014-11-13T00:00:00
|
|
|
yyyymmddThhmmss.fff/yyyymmddThhmmss.fff
|
20120915T155300/20141115T120000
|
|
|
PnYnMnDTnHnMn.fffS/yyyy-mm-ddThh:mm:ss.fff
|
P2y10M14dT20h13m45s/2012-09-15T15:53:00
|
|
|
yyyy-mm-ddThh:mm:ss.fff/PnYnMnDTnHnMn.fffS
|
2012-09-15T15:53:00/P2y10M14dT20h13m45s
|
|
Datetime
|
yyyy-mm-ddThh:mm:ss.fff
|
2012-09-15T15:53:00
|
|
|
yyyymmddThhmmss.fff
|
20120915T155300
|