CURRENT_TIME
Returns a value of type TIME WITH TIMEZONE
that represents the start of the current transaction.
The return value does not change during the transaction. Thus, multiple calls to CURRENT_TIME within the same transaction return the same timestamp.
Behavior Type
Syntax
CURRENT_TIME [ ( precision ) ]
If you specify a column label without precision, you must also omit parentheses.
Parameters
precision | An integer value between 0-6, specifies to round the seconds fraction field result to the specified number of digits. |
Examples
=> SELECT CURRENT_TIME(1) AS Time; Time --------------- 06:51:45.2-07 (1 row) => SELECT CURRENT_TIME(5) AS Time; Time ------------------- 06:51:45.18435-07 (1 row)