PostgreSQL CURRENT TIMESTAMP Function

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

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

Example : PostgreSQL CURRENT_TIMESTAMP() function

SELECT current_timestamp;

Output :

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

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