Previous Topic: Time (TME)Next Topic: Text (TXT)

Understanding Your Data Model › Using Fields › Defining Function Fields as REF Fields › ISO Timestamp (TS#)

ISO Timestamp (TS#)

The following table contains the default characteristics of TS# field.

Field Type Attribute

Shipped Default Value


Default Override

Field Details Override

Device Field Override

Implementation name

System data type

External length

Internal length

Decimal places

xxTS

Alpha

18.0

26

N

-

N

N

N

N

Y

N

N

N

N

N

N

N

N

N

LHS text (Column headings)

RHS text

Field name

Timestamp

N

Y

Y

Y

Y

Y

Keyboard shift

Allow lowercase

Mandatory fill

Valid system name

Mod10/11 check

DYN

-

-

-

-

N

-

Y

-

Y

N

-

Y

-

Y

N

-

N

-

N

Check condition

Translate values

*NONE

-

N

-

Y

-

Y

-

Field exit option

Edit codes: Input

Output

Report

blank

4

/

/

Y

Y

Y

Y

N

Y

Y

Y

Y

Y

Y

-

The TS# type is used for fields that represent timestamps. Since the TS# field type meets standards set by the International Standards Organization (ISO), timestamp fields of this type are interpreted correctly for SQL and Query Manager.CA 2E automatically generates code to validate TS# field.

ISO timestamp is stored internally in YYYY-MM-DD-HH.MM.SS.NNNNNN format. External formats are:

External Format

Valid Edit Codes

MM-DD-YYYY-HH:MM:SS or

YYYY-MM-DD-HH:MM:SS

MM/DD/YYYY/HH:MM:SS or

YYYY/MM/DD/HH:MM:SS

MM/DD/YY/HH:MM:SS:NNNNNN

-

/

T and Y

Note: A value of 0001-01-01-00.00.00.000000 on the physical file represents zero, not a valid timestamp.

The external format for TS# fields for both input and output also depends on the setting of the Date Generation Validation (YDATGEN) and Date Format (YDATFMT) model values.

For more information on how edit codes and the settings of YDATGEN and YDATFMT affect the way in which timestamps are displayed and printed, refer to the table in the description of the DT# field type in this chapter.

You can use the *MOVE built-in function to convert between timestamp fields and time and date fields.

CA 2E generates ISO timestamp as the i OS Timestamp type and assimilates i OS Timestamp fields as type TS#.

Examples of TS# fields include: