SQL_CURRENT_TIMESTAMP

Name

CURRENT_TIMESTAMP  --  Returns the current date and time.

Synopsis

  CURRENT_TIMESTAMP 
 

Parameters

This function does not accept parameters.

Results

timestamp

This function returns the current date and the current time.

Description

Use the CURRENT_TIMESTAMP function to retrieve the current date and time in a data type of TIMESTAMP.

Examples

Display CURRENT_TIMESTAMP:

   SELECT CURRENT_TIMESTAMP AS date_and_time;

   date_and_time
   ----------------------
   2001-03-31 07:41:21-08