MYSQL - DATE_FORMAT 함수

format 문자열에 따라 date 값을 구성합니다.

SELECT DATE_FORMAT(date, format);

#ex.1)
 mysql> SELECT DATE_FORMAT('2009-10-04 22:23:00', '%W %M %Y');
      -> Sunday October 2009

 mysql> SELECT DATE_FORMAT('2007-10-04 22:23:00', '%H %i %s');
      -> 22:23:00

 mysql> SELECT DATE_FORMAT('1900-10-04 22:23:00', '%D %y %a %d %m %b %j');
      -> 4th 00 Thu 04 10 Oct 277

 mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%H %k %l %r %T %S %w');
      -> 22 22 10 10:23:00 PM 22:23:00 00 6

 mysql> SELECT DATE_FORMAT('1999-01-01', '%X %V');
      -> 1998 52

 mysql> SELECT DATE_FORMAT('2006-06-00', '%d');
      -> 00