Skip to content

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