LOCALTIMESTAMP

LOCAL_TIMESTAMP returns a value of type TIMESTAMP representing today's date and time of day.

Syntax

LOCALTIMESTAMP [ ( precision ) ]

Semantics

precision

causes the result to be rounded to the specified number of fractional digits in the seconds field.

Notes

This function returns the start time of the current transaction; the value does not change during the transaction. The intent is to allow a single transaction to have a consistent notion of the "current" time, so that multiple modifications within the same transaction bear the same time stamp.

Examples

> SELECT LOCALTIMESTAMP;

timestamp

----------------------------

2007-10-26 16:58:58.349569

(1 row)