SQLWays Product Page - Migration to MySQL
Free Evaluation
Versions: MySQL 5.x, 4.x and 3.23
| MySQL - YEAR | |
|---|---|
| Syntax | YEAR[(2|4)] |
| Data | Year data |
| Range | 4 digit format: 1901 to 2155 and 0; 2 digit format: 70 to 69 (1970 to 2069) |
| Default | 4 digit format |
| Storage Size | 1 byte |
| Standards | MySQL Extension |
MySQL YEAR - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Informix | DATETIME YEAR TO YEAR |
Related Data Types in MySQL
| Data Types | |||
|---|---|---|---|
| Datetime | DATE | TIME | DATETIME |
| Auto-uptated datetime | TIMESTAMP | ||
All Data Types
| Oracle | SQL Server | IBM DB2 | MySQL | PostgreSQL | Sybase ASE | Sybase ASA | Informix DS | Teradata | HP Neoview | Interbase/Firebird |
Discussion