Formats

$N8601Xw.d Format

Writes ISO 8601 duration, datetime, and interval forms PnYnMnDTnHnMnS and yyyy-mm-ddThh:mm:ss, dropping omitted components in duration values and using an x for each digit of an omitted component in datetime values.

Category:	Date and Time
	ISO 8601
Alignment:	left
Time Zone Format:	No
ISO 8601 Element:	5.5.3, 5.5.4.1, 5.5.4.2

Syntax
Syntax Description
Details
Examples
See Also

Syntax

$N8601Xw.d

Syntax Description

w

specifies the width of the output 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 lowest order component. This argument is optional.

Default:	0
Range:	0 - 3

Details

The $N8601X format writes ISO 8601 durations, intervals, and datetimes in the following forms, omitting components in the PnYnMnDTnHnMnS form and using an x 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.

Examples

put nx $n8601x.;

Value of nx	Results
0002304FFFFFFFFC2008FFF15FFFFFFD	P2Y3M4D/2008-xx-xxT15:xx:xx
FFFF102FFFFFFFFD2008FFF15FFFFFFd	xxxx-01-02Txx:xx:xx/2008-xx-xxT15:xx:xx