The format in which DATE values are retrieved as strings by applications is controlled by the date_format creation parameter.
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 creation parameter.
Syntax