Skip to Content
0
Former Member
Sep 14, 2014 at 09:12 AM

command object help

17 Views

Hi All,

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 .

Please help.