CURRENT_TIMESTAMP
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_TIMESTAMP
within the same transaction return the same timestamp.
Behavior Type
Syntax
CURRENT_TIMESTAMP ( precision )
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_TIMESTAMP(1) AS time; time -------------------------- 2017-03-27 06:50:49.7-07 (1 row) => SELECT CURRENT_TIMESTAMP(5) AS time; time ------------------------------ 2017-03-27 06:50:49.69967-07 (1 row)