PostgreSQL CURRENT TIMESTAMP

Postgresql current_timestamp

This function returns the current date and time with time zone.

Syntax current_timestamp

current_timestamp;

Example 1

postgres=# SELECT current_timestamp;
              now              
-------------------------------
 2012-06-16 13:59:47.067008-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

---