w3resource

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

Pictorial presentation of PostgreSQL now() function

Example: PostgreSQL NOW() function:

Code:

SELECT now();

Sample 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.

Previous: LOCALTIMESTAMP function
Next: STATEMENT_TIMESTAMP function