TIMEOFDAY()
returns a text string representing the time of day.
Syntax
TIMEOFDAY()
Notes
TIMEOFDAY()
returns the wall-clock time and advances during transactions.Examples
> SELECT TIMEOFDAY();
timeofday
-------------------------------------
Fri Oct 26 18:10:45.637605 2007 EDT
(1 row)