来自文本列的Mysql GROUP BY DATE

I have a DB with a text column that will store the date and time as DD/MM/YYYY HH:MM:SS (example: 27-11-2015 17:01:53).I have a DB with a text column that will store