Book Contents

Book Index

Next Topic

Home

DATE

DATE consists of a month, day, and year. See SET DATESTYLE for information about ordering.

Syntax

DATE

Semantics

 

Low Value

High Value

Resolution

4713 BC

32767 AD

1 DAY

  

Example

Description

January 8, 1999

unambiguous in any datestyle input mode

1999-01-08

ISO 8601; January 8 in any mode (recommended format)

1/8/1999

January 8 in MDY mode; August 1 in DMY mode

1/18/1999

January 18 in MDY mode; rejected in other modes

01/02/03

January 2, 2003 in MDY mode
February 1, 2003 in DMY mode
February 3, 2001 in YMD mode

1999-Jan-08

January 8 in any mode

Jan-08-1999

January 8 in any mode

08-Jan-1999

January 8 in any mode

99-Jan-08

January 8 in YMD mode, else error

08-Jan-99

January 8, except error in YMD mode

Jan-08-99

January 8, except error in YMD mode

19990108

ISO 8601; January 8, 1999 in any mode

990108

ISO 8601; January 8, 1999 in any mode

1999.008

year and day of year

J2451187

Julian day

January 8, 99 BC

year 99 before the Common Era