The CURDATE() function in MySQL returns the current system date as a value formatted YYYY-MM-DD or YYYYMMDD, depending on the evaluation context. It requires zero arguments and explicitly strips the time component, making it suitable for date-specific operations.

Basic Execution

Running the function directly yeilds the current calendar day.

SELECT CURDATE() AS todays_date;

Integration with Date Operations

Pairing CURDATE() with interval or arithmetic functions facilitates dynamic temporal calculations. Examples include measuring elapsed time from a baseline or projecting past/future deadlines.

-- Calculate days elapsed since January 1st of the current year
SELECT DATEDIFF(CURDATE(), DATE(CONCAT(YEAR(CURDATE()), '-01-01'))) AS days_passed;

-- Determine the exact date seven days ago
SELECT DATE_SUB(CURDATE(), INTERVAL 1 WEEK) AS previous_week_date;

Automated Column Initialization

Database schemas can utilize CURDATE() to auto-populate date fields upon row insertion, removing the requirement for client-side date generation.

CREATE TABLE audit_logs (
    log_id BIGINT UNSIGNED AUTO_INCREMENT,
    entry_date DATE NOT NULL DEFAULT (CURDATE()),
    log_message VARCHAR(255),
    PRIMARY KEY (log_id)
);

Equivalent Functions Across Other Database Systems

While CURDATE() is MySQL-native, other relasional engines implement comparable functionality through distinct syntax.

PostgreSQL

PostgreSQL implements the ANSI standard CURRENT_DATE keyword, or developers can cast the full timestamp to a date type.

SELECT CURRENT_DATE AS pg_current_date;

-- Alternative approach using type casting
SELECT CURRENT_TIMESTAMP::DATE AS pg_casted_date;

Microsoft SQL Server

SQL Server extracts the date portion by casting GETDATE() or SYSDATETIME() to a DATE data type.

SELECT CAST(GETDATE() AS DATE) AS mssql_current_date;

-- String formatting alternative
SELECT FORMAT(SYSDATETIME(), 'yyyy-MM-dd') AS mssql_formatted_date;

Oracle Database

The SYSDATE function in Oracle returns both date and time. Wrapping it with TRUNC truncates the time fields to midnight, effectively returning a pure date value.

SELECT TRUNC(SYSDATE) AS oracle_current_date FROM DUAL;