LOCALTIME

LOCALTIME returns a value of type TIME representing the time of day.

Syntax

LOCALTIME [ ( 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 LOCALTIME;

time

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

16:58:58.349569

(1 row)