Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial

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

All Data Types


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