now() -> timestamp

Returns the current time for which the query is executed as timestamp.
This function is not accelerable.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

Examples

Create a column 'is_current' with value true if the current query executed time is greater than timestamp - 1h and false otherwise.