PostgreSQL TIMEOFDAY Function

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

PostgreSQL TIMEOFDAY() function

TIMEOFDAY() function

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

Syntax :


Return Type : text

PostgreSQL Version : 9.3

Pictorial Presentation

Example : PostgreSQL TIMEOFDAY() function

SELECT timeofday();

Output :

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

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