Name

rdf_now_impl — returns the current transaction timestamp

Synopsis

rdf_now_impl ( );

Description

This function 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

None

Examples

Example24.61.Simple example

Get a timestamp in human-readable form:

SQL> select rdf_now_impl();
DATETIME
2015-05-04 08:28:18.228407
No. of rows in result: 1