CURRENT

The CURRENT operator returns the current system date and time.

Syntax

CURRENT [ qual1 TO qual2 [(scale)] ]

qual1, qual2 and scale define the date time qualifier.

Usage

The CURRENT operator returns the system date/time in the current local timezone.

This operator can be used to assign the current system date and time to a DATETIME variable.

Use optional datetime qualifiers to specify the precision of the returned value. The possible qualifiers are the same as in a DATETIME data type definition.

If the datetime qualifiers are not specified after the CURRENT keyword, the precision defaults to YEAR TO FRACTION(3) precision.

Example

MAIN
  DISPLAY CURRENT YEAR TO FRACTION(4)
  DISPLAY CURRENT HOUR TO SECOND
  DISPLAY CURRENT
END MAIN