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