NOW

NOW() is equivalent to CURRENT_TIMESTAMP except that it does not accept a precision parameter. It returns a value of type TIMESTAMP WITH TIME ZONE representing today's date and time of day.

Syntax

NOW()

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 NOW();

now

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

2007-10-26 14:58:58.349569-06

(1 row)