Back to Function Index

CURDATE()

Overview

CURDATE() returns the current system date without any time component. This function is useful for date-based calculations, filtering, and reporting where only the date portion is needed. The date is returned in the system's default date format.

Function Format

CURDATE()

Return Value

CURDATE() returns a date value in the format YYYY-MM-DD

Examples

CURDATE()                    = 2024-03-19  (if run on March 19, 2024)
CURDATE() + 1               = 2024-03-20  (tomorrow's date)
CURDATE() - 1               = 2024-03-18  (yesterday's date)
CURDATE() + INTERVAL '1' MONTH = 2024-04-19  (next month)
CURDATE() + INTERVAL '1' YEAR  = 2025-03-19  (next year)

Notes

• The function returns only the date portion, with no time component.
• The returned date is based on the system's current date and timezone settings.
• Common use cases include:
  • Date-based filtering in queries
  • Age calculations
  • Date comparisons
  • Reporting and analytics
  • Date arithmetic operations
• The function can be used in date arithmetic operations:
  • Adding or subtracting days
  • Adding or subtracting months
  • Adding or subtracting years
• This function is equivalent to CURRENT_DATE in some database systems.

See Also

• DATE()