User Documentation
Ispirer Capabilities - MySQL Migration
Pricing
MySQL Data Types - YEAR
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
All Data Types