Tabular IQ
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