NBR

+

+

+

1

+

3

7

DTE

+

+

0

0

–

–

5

D8# (DT8) *

+

2

+

0

–

–

5

DT#

2

0

0

+

–

–

5

TME

+

–

–

–

+

3

6

TM#

4

–

–

–

4

+

6

TS#

8

9

9

9

10

10

+

* Conversions for the shipped D8# and the user-defined DT8 (8-digit
internal representation) data types are identical.

Explanations of codes used in this table:

+ No conversion.

– Does not apply.

0 Type conversion between internal formats.

1 Convert from CYYMMDD.

2 Convert to CYYMMDD

3 Insert delimiters.

4 Remove delimiters.

5 Convert date-to-date part of timestamp, time part is set to 0.

6 Convert time-to-time part of timestamp, date part is not affected.

7 Move numeric value as 6-digit nanoseconds part of timestamp.

  (Timestamp format is yyyy-mm-dd-hh.mm.ss.nnnnnn.)

8 Move 6-digit nanoseconds part of timestamp to numeric field.

  (Timestamp format is yyyy-mm-dd-hh.mm.ss.nnnnnn.)

9 Move date part of timestamp to date field.

10 Move time part of timestamp to time field.