DATE_FORMAT
dd.mm.yyyy (default) — Sets the date string format.
Wildcards:
dd
Day (01 - 31)
mm
Month, numerical (01 - 12)
mon
Month, three characters (Jan - Dec)
month
Month, full text (January - December)
yy
Year, using two characters (for example, 12)
yyyy
Year, using four characters (for example 2012)
DATE_FORMAT = dd. mon yyyy Creates the date string 01. Nov 2017.
DATE_FORMAT = yy-mm-dd Creates the date string 17-11-01.
Was this helpful?