SQL Language Guide : 3. Data Types : Data Types : Ansidate Data Type
 
Share this page                  
Ansidate Data Type
The ANSIDATE data type consists of a year, month, day. Input and output is in the format yyyy-mm-dd.
The declaration format is as follows:
ANSIDATE
Date Format
Input and Output Example
ANSIDATE
2006-05-16
A synonym for ANSIDATE is DATE.