w3resource

PostgreSQL CURRENT_TIMESTAMP() function

CURRENT_TIMESTAMP() function

This function is used to return the current date and time.

Syntax:

current_timestamp()

Return Type: timestamp with time zone.

PostgreSQL Version: 9.3

Pictorial Presentation of PostgreSQL CURRENT_TIMESTAMP() function

Pictorial presentation of postgresql CURRENT_TIMESTAMP function

Example: PostgreSQL CURRENT_TIMESTAMP() function

Code:

SELECT current_timestamp;

Sample Output:

            now
----------------------------
 2015-01-14 16:42:26.283-08
(1 row)

N.B. - The outputs may change with current date and time.

Previous: CURRENT_TIME function
Next: DATE_PART function