PostgreSQL LOCALTIMESTAMP Function

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

PostgreSQL LOCALTIMESTAMP() function

LOCALTIMESTAMP() function

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

Syntax :

localtimestamp

Return Type : timestamp

PostgreSQL Version : 9.3

Pictorial Presentation of PostgreSQL LOCALTIMESTAMP() function

 

Example : PostgreSQL LOCALTIMESTAMP() function

SELECT localtimestamp;

Output :

        timestamp
-------------------------
 2015-01-15 14:02:56.925
(1 row)

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