Formats

B8601DTw.d Format

Writes datetime values in the ISO 8601 basic notation yyyymmddThhmmssffffff.

Syntax

B8601DTw.d

w

specifies the width of the output field.

Default:	19
Range:	19 - 26

d

specifies the number of digits to the right of the seconds value that represents a fraction of a second. This argument is optional.

Default:	0
Range:	0 - 6

The B8601DT format writes ISO 8601 basic datetime notation yyyymmddThhmmssffffff:

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 - .

put bdt b8601dt.;

Value of bdt	Results
----+----1
1537113180	20080915T155300