PostgreSQL TRANSACTION TIMESTAMP

Postgresql transaction_timestamp

It is equal to the CURRENT_TIMESTAMP, however the transaction_timestamp() returns current date and time for the current transaction.

Syntax transaction_timestamp

 transaction_timestamp();

Example 1

postgres=# SELECT transaction_timestamp();
    transaction_timestamp     
------------------------------
 2012-06-17 00:57:58.28839-04
(1 row)

Related Links

• Postgresql Date and Time Functions
• Learning PostgreSQL
• Tutorial Home

---

• age
• clock_timestamp
• current_date
• current_time
• current_timestamp

• date_part
• date_trunc
• extract
• isfinite
• justify_days

• justify_hours
• justify_interval
• localtime
• localtimestamp
• now

• statement_timestamp
• timeofday
• transaction_timestamp

---