Ispirer Website
Ispirer Capabilities - MySQL Migration
Free Trial
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