$N8601Ew.d Informat
Reads ISO 8601 duration, datetime, and interval
values that are specified in the extended notation.
| 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 |
Syntax
Syntax Description
- w
-
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.
- d
-
specifies the number
of digits to the right of the decimal point in the seconds value.
This argument is optional.
Details
The $N8601E informat
reads ISO 8601 duration, interval, and datetime values that can be
specified in the following extended notations:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
yyyy-mm-ddT hh:mm:ss.fff/ yyyy-mm-ddT hh:mm:ss.fff
|
2012-09-15T15:53:00/2014-11-13T00:00:00
|
|
|
yyyy-mm-ddT hh:mm:ss.fff/P nY nM nDT nH nM ns.fffS
|
2012-09-15T15:53:00/P2Y10M14DT20H13M45S
|
|
|
|
|
specifies a number
that represents the number of years, months, or days.
is the character that
is used to indicate that the duration that follows is specified by
the number of years, months, days, hours, minutes, and seconds.
is the character that
is used to designate that the duration is specified in weeks.
is the character that
is used to designate that a time value follows. If all time values
are 0, T is not required.
in an interval, is
used to separate the beginning and ending datetime values.
specifies a four-digit
year.
specifies a two-digit
month between 01 and 12.
specifies a two-digit
day between 01 and 31.
specifies a two-digit
hour between 00 and 23.
specifies a two-digit
minute between 00 and 59.
specifies a two-digit
second between 00 and 59.
specifies an optional
fraction of a second with a precision of up to three digits, where
each digit is between 0 and 9.
is the character that
is used to designate years in a duration.
is the character that
is used to designate months in a duration.
is the character that
is used to designate days in a duration.
is the character that
is used to designate hours in a duration.
is the character that
is used to designate minutes in a duration.
is the character that
is used to designate seconds in a duration.
Comparisons
The $N8601E informat
reads valid durations, intervals, and datetimes that are specified
only in the extended notation.
The $N8601B informat
reads valid durations, intervals, and datetimes that are specified
in either the basic or extended notation.
Use the $N8601E informat
when you need to ensure compliance with the extended notation.
Example
|
|
|
|
|
|
2012-09-15T15:53:00/2014-09-15T00:00:00 |
2012915155300FFD2014915000000FFD |
p0033-01-04T3:2:55/2012-09-15T15:53:00 |
0033104030255FFC2012915155300FFD |