PostgreSQL NOW Function

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

PostgreSQL NOW() function

NOW() function

This function is used to get current date and time (start of current transaction).

Syntax :

now()

Return Type : timestamp with time zone

PostgreSQL Version : 9.3

Pictorial Presentation of PostgreSQL NOW() function

Example : PostgreSQL NOW() function :

SELECT now();

Output :

            now
----------------------------
 2015-01-15 14:17:25.919-08
(1 row)

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