SQL_CURRENT_DATE

Name

CURRENT_DATE  --  Returns the current date.

Synopsis

   CURRENT_DATE
   

Parameters

This function does not accept any parameters.

Results

date

The function returns the current date.

Description

Use the CURRENT_DATE function to retrieve the current system-recorded date as an object of data type DATE. Use SET DATASTYLE to format the date.

Examples

The following example retrieves the current date.

     
SELECT CURRENT_DATE AS today;

   today
   ------------
   2001-04-12