How to Get the Current Date and Time in Snowflake

Last updated July 24, 2026 · By the SaturnSQL team

CURRENT_DATE() returns the date, CURRENT_TIMESTAMP() the timestamp in the session time zone. Use DATEADD and DATE_TRUNC for offsets like yesterday or start of month.

SELECT CURRENT_DATE(), CURRENT_TIMESTAMP();

SELECT
  DATEADD(day, -1, CURRENT_DATE()) AS yesterday,
  DATEADD(day, -7, CURRENT_DATE()) AS week_ago,
  DATE_TRUNC('month', CURRENT_DATE()) AS month_start;