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

Example 24.62. 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
      


© 1992 - OpenLink Software. All rights reserved.

Making Technology Work for You®