NOW [Date/Time]
Returns a value of type TIMESTAMP WITH TIME ZONE representing the start of the current transaction. NOW is equivalent to CURRENT_TIMESTAMP
except that it does not accept a precision parameter.
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
NOW()
Example
=> CREATE TABLE t1 (a int, b int); CREATE TABLE => INSERT INTO t1 VALUES (1,2); OUTPUT -------- 1 (1 row) => SELECT NOW(); NOW ------------------------------ 2016-12-09 13:00:08.74685-05 (1 row) => INSERT INTO t1 VALUES (3,4); OUTPUT -------- 1 (1 row) => SELECT NOW(); NOW ------------------------------ 2016-12-09 13:00:08.74685-05 (1 row) => COMMIT; COMMIT dbadmin=> SELECT NOW(); NOW ------------------------------- 2016-12-09 13:01:31.420624-05 (1 row)