LOCALTIMESTAMP
Returns a value of type TIMESTAMP/TIMESTAMPTZ that represents the start of the current transaction, and remains unchanged until the transaction is closed. Thus, multiple calls to LOCALTIMESTAMP within a given transaction return the same timestamp.
Behavior Type
Syntax
LOCALTIMESTAMP [ ( precision ) ]
Parameters
precision |
Rounds the result to the specified number of fractional digits in the seconds field. |
Example
=> CREATE TABLE t1 (a int, b int); CREATE TABLE => INSERT INTO t1 VALUES (1,2); OUTPUT -------- 1 (1 row) => SELECT LOCALTIMESTAMP(2) AS 'local timestamp'; local timestamp ------------------------ 2021-03-05 10:48:58.26 (1 row) => INSERT INTO t1 VALUES (3,4); OUTPUT -------- 1 (1 row) => SELECT LOCALTIMESTAMP(2) AS 'local timestamp'; local timestamp ------------------------ 2021-03-05 10:48:58.26 (1 row) => COMMIT; COMMIT => SELECT LOCALTIMESTAMP(2) AS 'local timestamp'; local timestamp ------------------------ 2021-03-05 10:50:08.99 (1 row)