Writes ISO 8601 duration, datetime, and interval
forms by using the extended notations Pyyyy-mm-ddThh:mm:ss and yyyy-mm-ddThh:mm:ss, using an x for each digit of an omitted component.
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 lowest-order component. This argument
is optional.
Default:0
Range:0–3
Details
The $N8601EX format
writes ISO 8601 duration, datetime, and interval values as character
data, using a hyphen ( - ) to represent omitted components, for the
following extended notations:
Pyyyy-mm-ddThh:mm:ss
yyyy-mm-ddThh:mm:ss
Pyyyy-mm-ddThh:mm:ss/yyyy-mm-ddThh:mm:ss
yyyy-mm-ddThh:mm:ss/Pyyyy-mm-ddThh:mm:ss
yyyy-mm-ddThh:mm:ss/yyyy-mm-ddThh:mm:ss
Omitted datetime components
are always displayed; they are never truncated.