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

Question

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

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

标签： mysqlsql

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.

这个问题非常不清楚。希望这些信息可能会有所帮助。