PostgreSQL CURRENT TIME

Postgresql current_time

This function returns a current time with a time zone.

Syntax current_time

current_time;

Example 1

postgres=# SELECT current_time;
      timetz       
-------------------
 07:35:15.23554-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

---