SQL · Functions and expressions

current_date / now()

The current date or timestamp. now() includes time and time zone in PostgreSQL.

sqlRunnable example sql course

Syntax

current_date / now()

Example

Open in the lab

SELECT current_date AS today;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.