extend()

The system function DateTimeLib.extend converts a timestamp, time, or date into a longer or shorter timestamp value. Examples are as follows:
  DateTimeLib.extend(
    extensionField dateOrTimeOrTimeStamp in
    [, mask outputTimeStampMask in
    ])
  returns (result TIMESTAMP)
result

A variable of type TIMESTAMP.

extensionField

The name of a field of type TIMESTAMP, TIME, or DATE. The field contains the value to be extended or shortened.

mask
A string literal or constant that defines the mask of the timestamp value returned by the function. For details, see TIMESTAMP.

Related concepts
Syntax diagram for EGL functions

Related reference
Datetime expressions

Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.