WebCodeDoc

SQL CURRENT_DATE Function

Quick summary: The SQL CURRENT_DATE function returns the current date without time.

SQL CURRENT_DATE Syntax 

CURRENT_DATE
SQL

SQL CURRENT_DATE Basic examples 

SELECT CURRENT_DATE;
SQL
Output:
2026-02-08

Returns today’s date.

SQL CURRENT_DATE Real-world usage 

SELECT * FROM orders WHERE created_at >= CURRENT_DATE;
SQL
Output:
Today’s orders

Filters records created today.

SQL CURRENT_DATE Edge cases 

SELECT CURRENT_DATE = CURRENT_DATE;
SQL
Output:
true

Date remains constant within a query.

SQL CURRENT_DATE Common mistakes

Comparing CURRENT_DATE to timestamps

Time component is missing.

Incorrect
created_at = CURRENT_DATE
Correct
created_at >= CURRENT_DATE AND created_at < CURRENT_DATE + INTERVAL 1 DAY

Use date ranges for timestamps.

SQL CURRENT_DATE Frequently Asked Questions

What does CURRENT_DATE do in SQL?

Returns the current date without time.

Use case?

Date comparisons.

Return type?

Date.

Common mistake?

Expecting time component.

Alternative?

CURDATE() (MySQL).

Used in WHERE?

Yes.

Performance?

Fast.

Supports timezone?

Depends on DB.

Used in filters?

Yes.

Used in reports?

Yes.

Stable per query?

Yes.

Best practice?

Use for date-only logic.

SQL CURRENT_DATE Related SQL Keywords