APPX Software Library

Chapter 4: SQL Language Elements

4.9.2.21 CURTIME function (ODBC compatible)

Syntax

CURTIME ()

Description

CURTIME returns the current time as a TIME value. This function takes no arguments.

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

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