Zachary Burt Zachary Burt - 3 years ago 135
MySQL Question

How to cast DATETIME as a DATE in mysql?

My query is this. I have a bunch of entries and i want to group them by date. But instead of having date in my database, I have a datetime field. What do I do?

select * from follow_queue group by follow_date cast follow_date as date

That's not working.


Answer Source

Use DATE() function:

select * from follow_queue group by DATE(follow_date)
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download