Name

current_timestamp — returns the current transaction timestamp

Synopsis

current_timestamp ( );

Description

Now returns the timestamp associated with current transaction as a DATETIME .

The function name refer to one function ( alias of now() ) that returns the timestamp of current transaction. It is the datetime of the beginning of current transaction with the fractional part of seconds replaced with serial number of a transaction within the second. If TimezonelessDatetimes=0 then the time has local timezone offset (as it was set at the time of last server start); otherwise it is timezoneless.

Parameters

current_timestamp has no parameters.

Return Types

A DATETIME timestamp.

Errors

current_timestamp does not return errors.

Examples

Example24.62.Simple example

SQL>select current_timestamp ;
DATETIME
 2015-05-05 03:36:41.225581