NOW()
Return the current date and time (as of the start of the current transaction).
NOW()
The parentheses are required.
premdb=# select now();
now
-------------------------------
2016-05-23 15:10:23.717069-07
(1 row)
The following example casts the result of the NOW()
function to the TIME
data type:
premdb=# select now()::time;
now
-----------------
17:09:56.469561
(1 row)
Parent topic:Datetime Functions