command object help
I have a report having command object like this.My back end is MYSQL.
I am not getting data in designer with below query
SELECT * FROM clock_time WHERE STR_TO_DATE(DATE_FORMAT(clock_time,'%d-%m-%Y %H:%i'),'%d-%m-%Y %H:%i')= DATE_FORMAT('2014-06-19 11:03:43','%d-%m-%Y %H:%i')
What is the mistake I am doing .