minte9

LearnRemember

Format

Formats the date value.

 
SELECT <span class='keyword_code'>DATE_FORMAT</span>('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 <span class='keyword_code'>STR_TO_DATE</span>('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', <span class='keyword_code'>GET_FORMAT</span>(DATE, 'EUR'));

        -> '03.10.2003'