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