CURRENT_TIME

CURRENT_TIME returns a value of type TIME WITH TIME ZONE representing the time of day.

Syntax

CURRENT_TIME [ ( precision ) ]

Semantics

precision

(INTEGER) 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 CURRENT_TIME;

timetz

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

16:58:58.349569-04

(1 row)