Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

CURRENT_DATE SQL function

Syntax

CURRENT_DATE

Description

CURRENT_DATE returns the current date as a DATE value. A FairCom DB SQL statement can refer to CURRENT_DATE anywhere you can refer to a DATE expression.

Example

INSERT INTO objects(object_owner, object_id,create_date)

VALUES(user, 1002, CURRENT_DATE) ;

Note: SQL-99 compatible

TOCIndex