TIME()

The TIME() operator returns a time part of the date time expression.

Syntax

TIME [(datetime-expr)]

datetime-expr is a datetime expression.

Usage

TIME() converts the time-of-day portion of its datetime operand to a character string.

This operator converts a date time expression to a character string representing the time-of-day part of its operand.

The format of the returned string is always "hh:mm:ss".

If you supply no operand, it returns a character representation of the current time. You can use the CURRENT operator to get a datetime result of the current system time.

MAIN
  DISPLAY TIME ( CURRENT )
END MAIN