PostgreSQL TIMEOFDAY

Postgresql timeofday

Returns current date and time as a string. Similar to PostgreSQL CLOCK TIMESTAMP.

Syntax timeofday

 timeofday();

Example 1

postgres=# SELECT timeofday();
              timeofday              
-------------------------------------
 Sun Jun 17 00:45:15.036850 2012 EDT
(1 row)

postgres=# SELECT timeofday();
              timeofday              
-------------------------------------
 Sun Jun 17 00:45:32.160116 2012 EDT
(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

---