Skip to content
masterclass Buddy
Start learning

PostgreSQL · Function

now

In PostgreSQL, now and now() mean the current date and time at the start of the current transaction. Other functions provide statement-start time, actual wall-clock time, or formatted text.

Last updated

Syntax

now() → timestamp with time zone
transaction_timestamp() → timestamp with time zone
statement_timestamp() → timestamp with time zone
clock_timestamp() → timestamp with time zone
timeofday() → text

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • CURRENT_TIMESTAMP
  • now()
  • transaction_timestamp()
  • statement_timestamp()
  • clock_timestamp()
  • timeofday()
  • TIMESTAMP 'now'

Source: PostgreSQL: Documentation: 18: 9.9. Date/Time Functions and Operators. Checked 2026-11-03.