如何在MySQL数据库中获取每日数据

Question

db截图如何在MySQL数据库中获得明智的数据预期的输出

ID   |   Name  |   DAY
--------------------------
1    |    A    |   SAT
2    |    B    |   SAT
3    |    C    |   SUN
4    |    D    |   MON
5    |    E    |   TUES
6    |    F    |   WED

Answer 1

如果您将receive_date设置为日期时间格式

select id as ID, 
name as Name, 
upper(date_format(receive_date, '%a')) as DAY 
from table_name ;

如果你只有receive_day

select id as ID, name as Name, upper(receive_day) from table_name.

这个问题很不清楚。希望这些信息对你有帮助。