w3resource

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

Pictorial presentation of PostgreSQL LOCALTIMESTAMP() function

Example: PostgreSQL LOCALTIMESTAMP() function 

SELECT localtimestamp;

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

Previous: JUSTIFY_INTERVAL function
Next: NOW function