APPX Software Library

Chapter 4: SQL Language Elements

4.9.2.83 SYSTIME function (extension)

Syntax

SYSTIME [ ( ) ]

Description

SYSTIME returns the current time as a TIME value. This function takes no arguments, and the trailing parentheses are optional.

SQL statements can refer to SYSTIME anywhere they can refer to a TIME expression. For example,

INSERT INTO objects (object_owner, object_id, create_time)
           VALUES (USER, 1001, SYSTIME) ;