PostgreSQL STATEMENT TIMESTAMP

Postgresql statement_timestamp

This function returns the current date and time with time zone(more specifically, the time of receipt of the latest command message from the client).

Syntax statement_timestamp

statement_timestamp();

Example 1

postgres=# SELECT statement_timestamp();
      statement_timestamp      
-------------------------------
 2012-06-17 00:41:31.058876-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

---