How to Get the Current Date and Time in ClickHouse

Last updated July 25, 2026 · By the SaturnSQL team

now() returns the current DateTime and today() the current Date; yesterday() also exists. Use toStartOfDay, toStartOfHour, and friends to truncate timestamps, and pass a timezone name to now() for zone-aware values.

SELECT now(), today(), yesterday(), toStartOfDay(now());

SELECT now('Europe/Helsinki'), toDate(now(), 'America/New_York');