602SQL Documentation Index  
<­EXTRACT Function UpFunctions Defined by the SQL Standard NULLIF Function­>

Functions for Current Time and Date (SQL)

CURRENT_DATE  
CURRENT_TIME  
CURRENT_TIMESTAMP

These functions return the current date, time and time with the date at the instant the function was called.

Example:

These functions are used in the table design as default values:

CREATE TABLE `TabTemp` (
number SMALLINT ,
date DATE DEFAULT CURRENT_DATE ,
time TIME DEFAULT CURRENT_TIME ,
datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP ,
CONSTRAINT `INDEX1` PRIMARY KEY (`number`))
<­EXTRACT Function UpFunctions Defined by the SQL Standard NULLIF Function­>