PostgreSQL LOCALTIMESTAMP() function

LOCALTIMESTAMP() function

The PostgreSQL LOCALTIMESTAMP() function is used to get the current date and time at the start of the current transaction.

Uses of LOCALTIMESTAMP() Function

• Retrieve the current date and time without a time zone.


• Obtain a consistent timestamp for the duration of the current transaction.


• Useful in logging and auditing to capture the exact time a transaction started.

Syntax:

localtimestamp

Return Type: timestamp

PostgreSQL Version: 9.3

Pictorial Presentation of PostgreSQL LOCALTIMESTAMP() function

Example: PostgreSQL LOCALTIMESTAMP() function

SELECT localtimestamp;

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