DATE

The format in which DATE values are retrieved as strings by applications is controlled by the date_format option setting. For example, a DATE value representing the 19th of July, 2010 can be returned to an application as 2010/07/19, or as Jul 19, 2010 depending on the date_format option setting.

A DATE value requires 4 bytes of storage.

• CURRENT TIME special value
• CURRENT TIMESTAMP special value
• Date and time functions
• Date formats
• DATE function [Date and time]
• date_format option
• date_order option
• DATETIME data type
• DATETIME function [Date and time]
• DATETIMEOFFSET data type
• ISDATE function [Data type conversion]
• nearest_century option
• NOW function [Date and time]
• SMALLDATETIME data type
• TIME data type
• TIMESTAMP data type
• TIMESTAMP special value
• TIMESTAMP WITH TIME ZONE data type
• UTC TIMESTAMP special value