SQL Server Data Types - DATE

Versions: SQL Server 2008

SQL Server - DATE
Syntax	DATE
Data	Date data (year, month and day)
Range	January 01, 0001 to December 31, 9999
Version Differences	DATE is available since SQL Server 2008
Storage Size	3 bytes
Standards	ANSI SQL

SQL Server DATE - Equivalents in Other Databases

Database	Data Type and Conversion
Oracle	DATE, January 01, 4712 BC to December 31, 9999. Contains time part (hours, minutes and seconds)
MySQL	DATE, January 01, 1000 to December 31, 9999
PostgreSQL	DATE, January 01, 4713 BC to December 31, 5874897
Sybase ASE	DATE, January 01, 0001 to December 31, 9999
Informix	DATE, January 01, 0001 to December 31, 9999
HP Neoview	DATE, January 01, 0001 to December 31, 9999
Ingres	DATE, 0001-01-01 to 9999-12-31

Related Data Types in SQL Server

Data Types
Datetime	TIME	DATETIME	DATETIME2	DATETIMEOFFSET	SMALLDATETIME

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird

HiRDB

Ingres