w3resource

PostgreSQL TRANSACTION

TRANSACTION_TIMESTAMP() function

This function is used to get current date and time (start of current transaction)

Syntax:

timeofday()

Return Type: text

PostgreSQL Version: 9.3

Pictorial Presentation of PostgreSQL TRANSACTION_TIMESTAMP() function

Pictorial presentation of PostgreSQL TRANSACTION_TIMESTAMP() function

Example: PostgreSQL TRANSACTION_TIMESTAMP() function

Code:

SELECT timeofday();

Sample Output:

   transaction_timestamp
----------------------------
 2015-01-15 14:57:22.598-08
(1 row)

N.B. - The outputs may change during the execution for the current date.

Previous: TIMEOFDAY function
Next: Mathematical and Trigonomitecal functions Introduction