SQL & PL/SQL

Hello,

    I am using the code shown below from a cold fusion page. I am able to run it successfully for any date values other than values of the format 2019/05/13 00:00:00

This code breaks and does not run for the time format 00:00:00 for any other time formats it works. No specific error is being thrown just the output is blank. How can I rectify this ?

BEGIN dbo.multi_report_pkg.run_multi_report(4549,

      'fquresh2',

      7,

      TO_DATE('2019/05/01 00:00:00','YYYY/MM/DD HH24:MI:SS','AMERICAN'),

      TO_DATE('2019/05/01 23:59:00','YYYY/MM/DD HH24:MI:SS','AMERICAN'),        

      2);

END;

Thanks

IQ