Previous Topic: Date FunctionsNext Topic: String Functions


Date-Time Stamp Functions

Date-time stamp built-in functions convert external date-time stamps to internal date-time stamps. Conversely, internal date-time stamps can be converted to external date-time stamps. The date-time stamp built-in functions call the date-time functions of IDMSIN01.

Note: For more information about IDMSIN01, see the CA IDMS Callable Services Guide.

In the following table, 8-byte binary fields are defined as PIC 9(16) COMPUTATIONAL fields, while display fields are defined with PIC X definitions.

Note: For more information about the date-time stamp formats used by the date-time stamp functions, see the chapter "Representation of Date/Time Values" in the CA IDMS SQL Reference Guide.

Function

Keyword

What it does

External Date

DATEEXT

Returns a 10-byte external date stamp as an 8-byte internal binary date stamp

Internal Date

DATEINT

Returns an 8-byte internal binary date stamp as a displayable 10-byte date stamp

Display Date Time

DISPDT

Returns the current date-time stamp as a 26-byte displayable date-time stamp

External Date-Time

DATETIMX

Returns a 26-byte external date-time stamp as an 8-byte internal binary date-time stamp

Internal Date-Time

DTINT

Returns an 8-byte internal date-time stamp as a 26-byte displayable date-time stamp

External Time

TIMEEXT

Returns an 8-byte displayable time stamp as an 8-byte binary time stamp

Internal Time

TIMEINT

Returns an 8-byte internal time stamp as a displayable 8-byte time stamp