3. Understanding SQL Data Types : SQL Data Types : Date and Time Data Types : Date Data Type
 
Share this page                  
Date Data Type
The declaration format of the date type can be one of the following:
DATE
ANSIDATE
INGRESDATE
Examples:
Date Format
Example
DATE
The keyword DATE used for a column data type is an alias, which can be configured to either ANSIDATE or INGRESDATE by setting the configuration parameter date_alias.
ANSIDATE
2006-05-16
INGRESDATE
For more information, see Ingresdate Data Types (see Ingresdate Data Types).