
| Data type | Format | Range |
| ---------- | ------ | ----- |
| DATE | 'YYYY-MM-DD' | '0001-01-01' to '9999-12-31' |
| DATETIME[(f)] | 'YYYY-MM-DD hh:mm:ss[.fraction]' | '1753-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999' | 
| TIME[(f)] | 'hh:mm:ss[.fraction]' | '00:00:00.0000000' to '23:59:59.000000' | 
| YEAR[(2/4)] | 'YY'/'YYYY'(default) | Year represented in 2 or 4 digits|


Note: f refers to fractional seconds precision


About Microsoft SQL Server

Installation on Linux and Windows

Introduction

Numeric Data Types

Date and Time

String Data Types

Data Types

Constraints

Commands

DDL Commands

DML Commands

DCL Commands

TCL Commands

Microsoft SQL Server Commands

Joins

Indexes

Triggers

Views

Stored Procedures

Data type	Format	Range
DATE	'YYYY-MM-DD'	'0001-01-01' to '9999-12-31'
DATETIME[(f)]	'YYYY-MM-DD hh:mm:ss[.fraction]'	'1753-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999'
TIME[(f)]	'hh:mm:ss[.fraction]'	'00:00:00.0000000' to '23:59:59.000000'
YEAR[(2/4)]	'YY'/'YYYY'(default)	Year represented in 2 or 4 digits