2. SQL 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.