postgresql when it's not your job


Does anyone really know what time it is?

7 August 2018

PostgreSQL has a variety of ways of telling time: now(), statement_timestamp(), and clock_timestamp(). Each has a different sense of when “now” is:

Each has its uses:

Bruce Momjian at 19:08, 7 August 2018:

FYI, for symmetry, ‘now’ is the same as transaction_timestamp.

Xof at 19:11, 7 August 2018:

Indeed so, but now() is so firmly imperative. :)