Skip to main content

CURRENT_DATE function

Returns the current date.

Syntax

CURRENT_DATE

Arguments

This function takes no arguments.

Returns

A DATE representing the current date in UTC.

Examples

-- Example 1: Get current date
> SELECT CURRENT_DATE;
2025-01-15

-- Example 2: Filter records from today
> SELECT * FROM orders 
  WHERE order_date = CURRENT_DATE;

-- Example 3: Calculate age in days
> SELECT DATEDIFF(DAY, birth_date, CURRENT_DATE) AS age_in_days
  FROM employees;

-- Example 4: Find records from the last 7 days
> SELECT * FROM events 
  WHERE event_date >= CURRENT_DATE - INTERVAL '7' DAY;

-- Example 5: Using in date arithmetic
> SELECT CURRENT_DATE + INTERVAL '30' DAY AS date_in_30_days;

See Also