DATE

DATE is a SQL data type in the Data Types category. Stores a date value (YYYY-MM-DD). Range: 1000-01-01 to 9999-12-31. The syntax is DATE. It returns date. A typical example: CREATE TABLE events (event_date DATE); INSERT INTO events VALUES ('2026-06-06'); A close relative is INT, which standard integer type. Range: -2147483648 to 2147483647 (signed). Use BIGINT for larger values. A close relative is VARCHAR(n), which variable-length string with a maximum length. Most common string type. Efficient for varying-length data. A close relative is TEXT, which for large text content (up to 65535 bytes in MySQL). Variants: TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT. More about this category: SQL column data types — INT, VARCHAR, TEXT, BOOLEAN, DATE, TIMESTAMP, JSON, DECIMAL. Related Data Types entries: INT, VARCHAR(n), TEXT, BOOLEAN / BOOL, TIMESTAMP / DATETIME, DECIMAL / NUMERIC, JSON, FLOAT / DOUBLE. This page is part of the free SQL Reference documentation covering 762+ statements, functions, and clauses, each with syntax, parameters, return values, and examples for MySQL, PostgreSQL, SQL Server, and SQLite.