CURRENT_TIMESTAMP Function

Returns the date and time for your time zone.

Category: Date and Time
Alias: LOCALTIMESTAMP
Returned data type: TIMESTAMP

Syntax

CURRENT_TIMESTAMP

Comparisons

The CURRENT_TIMESTAMP function returns the date and time for your time zone.

Example

The following statement illustrates the CURRENT_TIMESTAMP function:
Statements
Results
select current_timestamp;
05FEB2014:11:06:05
select localtimestamp;
05FEB2014:11:06:05