---

1. 環境

mysql version : mysql Ver 14.14 Distrib 5.7.11, for Win64 (x86_64)

2. SQL文

* date1 : datetime type

select date1
      ,(case DATE_FORMAT(date1, '%w') 
           when 1 then '月' 
           when 2 then '火' 
           when 3 then '水' 
           when 4 then '木' 
           when 5 then '金' 
           when 6 then '土' 
           when 7 then '日' 
           else 'x' end) as date_name
from [table_name];

3.結果

date1 date_name
--------------------------------
2016-06-13 10:10:00 月