Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

SYSDATE function (extension)

Syntax

SYSDATE [ ( ) ]

Description

SYSDATE returns the current date as a DATE value. This function takes no arguments, and the trailing parentheses are optional.

FairCom DB SQL statements can refer to SYSDATE anywhere they can refer to a DATE expression. For example,

INSERT INTO objects (object_owner, object_id, create_date)

VALUES (USER, 1001, SYSDATE) ;

TOCIndex