mysql 日期转周,MySQL将日期转换为星期几

I have the following query which gives me the visit_date for each client:

select visit_date from visit

The output of the above query is the timestamp when the entry was inserted into the Database , it will appear as follows :

visit_date

2013-12-21 06:31:04

2013-12-21 11:05:30

2013-12-21 23:03:12

How can I convert the above date to days of the week in MySQL?

解决方案

Check MySQL DATETIME FUNCTIONS to fetch day of week or day name or day of month or day of year

Try this:

SELECT DAYOFWEEK(visit_date) FROM visit;

SELECT DAYNAME(visit_date) FROM visit;

SELECT DAYOFMONTH(visit_date) FROM visit;

SELECT DAYOFYEAR(visit_date) FROM visit;