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

Data Types
Datetime DATE TIME DATETIME
Auto-uptated datetime TIMESTAMP

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.