Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

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.

FairCom DB 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) ;

TOCIndex