date description

data-types

#tsql#data-types

Analytics Platform System (PDW)

SQL analytics endpoint in

Microsoft Fabric

Warehouse in Microsoft Fabric

Defines a date in SQL Server. The

data type was introduced in SQL Server 2008 (10.0.x).

Syntax

Usage

Default string literal format

(used for down-level

client)

For more information, see the

Backward compatibility for down-level clients

section.

Range

through

(

through

for

Informatica)

January 1, 1 CE (Common Era) through December 31, 9999 CE (October 15,

1582 CE through December 31, 9999 CE for Informatica)

Element ranges

is four digits from

that represent a year. Informatica

limits

to the range

to.

is two digits from

that represent a month in the specified year.

is two digits from

, depending on the month, which represents

a day of the specified month.

Character length

10 positions

Precision, scale

Storage size

3 bytes, fixed

Storage structure

one 3-byte integer stores

Accuracy

One day

Expand table

DATE

DECLARE @MyDate DATE
CREATE TABLE Table1 (Column1 DATE)

yyyy-MM-dd

0001-01-01

9999-12-31

1582-10-15

9999-12-31

yyyy

MM

dd

10, 0