E8601DZw.d Informat

Reads Coordinated Universal Time (UTC) datetime values that are specified using the ISO 8601 datetime extended notation yyyy-mm-ddThh:mm:ss+|–hh:mm.<fffff> or yyyy-mm-ddThh:mm:ss.<fffff>Z.

Categories: Date and Time
ISO 8601
Alignment: Left
Aliases: E8601DXw.d
IS8601DZw.d
Supports: ISO 8601 Element 5.4.1, complete representation

Syntax

E8601DZw.d

Syntax Description

w

specifies the width of the input field.

Default 26
Range 20–35

d

specifies the number of digits to the right of the decimal point in the value for the lowest-order component. This argument is optional.

Default 0
Range 0–6

Details

UTC values specify a time and a time zone based on the zero meridian in Greenwich, England. The E8601DZ informat reads datetime values that contain UTC time offsets and that are specified in one of the following ISO 8601 extended datetime notations:
  • yyyy-mm-ddThh:mm:ss.<ffffff>+|–hh:mm
  • yyyy-mm-ddThh:mm:ss.<ffffff>Z
yyyy
is a four-digit year.
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 and 24.
mm
is a two-digit minute (zero padded) between 00 and 59.
ss
is a two-digit second (zero padded) between 00 and 59.
ffffff
are optional fractional seconds, with a precision of up to six digits, where each digit is between 0 and 9.
+|–hh:mm
is an hour and minute signed offset from zero meridian time. Note that the offset must be +|–hh:mm (that is, + or – and five characters).
Use + for time zones east of the zero meridian, and use – for time zones west of the zero meridian. For example, +02:00 indicates a two-hour time difference to the east of the zero meridian, and –06:00 indicates a six-hour time difference to the west of the zero meridian.
Restriction: The shorter form +|–hh is not supported.
Z
indicates that the time is UTC time at the zero meridian (Greenwich, England).

Example

Input Statement
Data Line
Result
----1----+----2----+----3
input edz e8601dz.;
2012-09-15T15:53:00Z
1663343580
input edz  e8601dz28.2;
2012-09-15T15:53:00+03:00
1663332780