Beginner

261. CURRENT_DATE

Learn how to retrieve the current date from the database system.

📘 Lesson 261 of 728 ⏱ 8 min 🎯 Beginner

CURRENT_DATE returns the current date according to the database session or system context.

Current dates are frequently required for reporting, date filtering, aging calculations, and business rules.

Find records created on the current date.

SQL 
SELECT
    CURRENT_DATE AS Today;

CURRENT_DATE is useful for daily reports, transaction monitoring, aging analysis, and date-based business rules.

  • CURRENT_DATE returns the current date.
  • It normally does not include a time component.
  • The result depends on the database context.
  • It is useful for date comparisons.
  • Syntax may vary between databases.
What does CURRENT_DATE return?

CURRENT_DATE returns the current date according to the database session or system context.

Where is CURRENT_DATE useful?

It is useful for daily reporting, date filtering, aging calculations, and current-date business rules.

Have you finished this lesson?

Introduction to SQL – All Lessons