Writes ISO 8601 duration, datetime, and interval
forms PnYnMnDTnHnMnS and yyyy-mm-ddThh:mm:ss, dropping omitted
components in duration values and using a hyphen ( - ) for omitted
components in datetime values.
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 $N8601H format writes
ISO 8601 durations, intervals, and datetimes in the following forms,
omitting components in the PnYnMnDTnHnMnS form and using a hyphen
( - ) to represent omitted components in the datetime form:
PnYnMnDTnHnMnS
yyyy-mm-ddThh:mm:ss
PnYnMnDTnHnMnS/yyyy-mm-ddThh:mm:ss
yyyy-mm-ddThh:mm:ssT/PnYnMnDTnHnMnS
yyyy-mm-ddThh:mm:ss/yyyy-mm-ddThh:mm:ss
Omitted datetime components
are always displayed; they are never truncated.