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

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