minte9
LearnRemember   MYSQL





Format

Formats the date value. 
 
SELECT DATE_FORMAT('2009-10-04 22:23:00', '%W %M %Y');

    -> 'Sunday October 2009'

String to Date / String

This is the inverse of the DATE_FORMAT() function. 
 
SELECT STR_TO_DATE('01,5,2013','%d,%m,%Y');

        -> 2013-05-01

Get date format / Get

Returns a format string from current date. Useful in combination with the DATE_FORMAT() and the STR_TO_DATE() functions. 
 
SELECT DATE_FORMAT('2003-10-03', GET_FORMAT(DATE, 'EUR'));

        -> '03.10.2003'




References: