datatype problem

In case 2 of operation analytics and investigation spike metrics, the occurredat coloumn in the table events and emailevents is in 'text' datatype. So I'm unable to get desired result in my mysql workbench as the result is showing null value while calculating week. And I've also tried changing the datatype to 'datetime' but it is not working. please share a solution to this.