MYSQLで、日付文字列に日本語の曜日を含めて返す

関数にするべきなのだろうが・・・。
（そんなに高速である必要もないので）

SELECT
  CONCAT (
    DATE_FORMAT(HIZUKE,"%m月%d日"),
    "(", ELT(WEEKDAY(HIZUKE)+1,"月","火","水","木","金","土","日"), ") ",
    DATE_FORMAT (HIZUKE, " %H時%i分")
  ) AS DATE, *
FROM DATABASE_NAME.TABLE_NAME