EXTEND()

Syntax

EXTEND ( dt-expr, qual1 TO qual2 [(scale)])

1. dt-expr is a date / time expression.
2. qual1, qual2 and scale define the date time qualifier.

Usage

The EXTEND() operator is used to convert a date time expression to a DATETIME value with a different precision.

The default qualifier is YEAR TO DAY.

The possible qualifiers are the same as in a DATETIME data type definition.

The expressions passed as first parameter must be a valid datetime value. If it is a character string, it must consist of valid and unambiguous time-unit values and separators, but with these restrictions:

• It cannot be a character string in date format, such as "12/12/99".
• It cannot be an ambiguous numeric datetime value, such as "05:06" or "05".
• It cannot be a time expression that returns an INTERVAL value.

MAIN
  DISPLAY EXTEND ( TODAY, YEAR TO FRACTION(4) )
END MAIN