SQL · Date and time functions

now()

The current transaction timestamp. PostgreSQL; SQLite uses current_timestamp.

sqlRunnable example sql course

Syntax

now()

Example

Open in the lab

SELECT current_timestamp AS now;

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