Formats

E8601DTw.d Format

Writes datetime values in the ISO 8601 extended notation yyyy-mm-ddThh:mm:ss.ffffff.

Syntax

E8601DTw.d

w

specifies the width of the input field.

Default:	19
Range:	19 - 26

d

specifies the number of digits to the right of the decimal point in the seconds value. This argument is optional.

Default:	0
Range:	0 - 6

The E8602DT format writes datetime values using the ISO 8601 extended datetime notation yyyy-mm-ddThh:mm:ss.ffffff:

yyyy	is a four-digit year, such as 2008.
mm	is a two-digit month (zero padded) between 01 and 12.
dd	is a two-digit day of the month (zero padded) between 01 and 31.
hh	is a two-digit hour (zero padded), between 00 - 23.
mm	is a two-digit minute (zero padded), between 00 - 59.
ss	is a two-digit second (zero padded), between 00 - 59.
.ffffff	are optional fractional seconds, with a precision of up to six digits, where each digit is between 0 - 9.

put edt e8601dt.;

Value of edt	Results
1537113180	2008-09-15T15:53:00