Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

command object help

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.

Tags:
Former Member
replied

Yes, if it works fine in both the Designer and the database, then this is correct.

-Abhilash

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question