Date and time functions
CURRENT_TIMESTAMP
Reference material for CURRENT_TIMESTAMP function
Returns the current timestamp as a TIMESTAMPTZ
value.
Alias: NOW
Syntax
The function can be called with or without parentheses:
Return Type
TIMESTAMPTZ
Remarks
The function gets the current timestamp from the system, and returns it as a TIMESTAMPTZ
value.
Example
The following example assumes that the current Unix timestamp is 2023-03-03 14:42:31.123456 UTC
.