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
Example 24.63. Simple example
SQL>select current_timestamp ;
DATETIME
2015-05-05 03:36:41.225581