CURRENT_TIMESTAMP

CURRENT_TIMESTAMP returns a value of type TIMESTAMP WITH TIME ZONE representing today's date and time of day.

Syntax

CURRENT_TIMESTAMP [ ( 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_TIMESTAMP;

timestamptz

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

2007-10-26 16:58:58.349569-04

(1 row)