w3resource

PostgreSQL TIMEOFDAY() function

TIMEOFDAY() function

This function is used to get current date and time (like clock_timestamp, but as a text string).

Syntax:

timeofday()

Return Type: text

PostgreSQL Version: 9.3

Pictorial Presentation

Pictorial presentation of PostgreSQL TIMEOFDAY() function

Example: PostgreSQL TIMEOFDAY() function

Code:

SELECT timeofday();

Sample Output: 

              timeofday
-------------------------------------
 Thu Jan 15 14:47:28.937000 2015 PST
(1 row)

N.B. - The outputs may change during the execution for the current date.

Previous: STATEMENT_TIMESTAMP function
Next: TRANSACTION_TIMESTAMP function