current_timestamp → timestamp with time zoneCurrent date and time (start of current transaction); see Section 9.9.5
current_timestamp → 2019-12-23 14:39:53.662522-05
FUNCTIONS / DATE/TIME FUNCTIONS AND OPERATORS
current_timestamp
Read PG 18 manual ↗Current date and time (start of current transaction); see Section 9.9.5
Signatures & examples
current_timestamp ( integer ) → timestamp with time zoneCurrent date and time (start of current transaction), with limited precision; see Section 9.9.5
current_timestamp(0) → 2019-12-23 14:39:53-05
CURRENT_TIMESTAMP(precision) LOCALTIME LOCALTIMESTAMP
CURRENT_TIME and CURRENT_TIMESTAMP deliver values with time zone; LOCALTIME and LOCALTIMESTAMP deliver values without time zone.Version history 2
- PG 13 → 14changed
- PG 12 → 13changed
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source