SQL Language Guide > SQL Language Guide > Data Types > Data Types > Ansidate Data Type
Was this helpful?
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.
Last modified date: 03/21/2024