ORA-01861: literal does not match format string

Hello,

Application team is getting the below error while running the below sql on oracle 11g, please helps us to fix this issue

Enter value for startd: old 8: where so_start_date between to_date('&&startd'||substr(d.value,-6),'mm/dd/yyyyhh24miss')

new 8: where so_start_date between to_date(''||substr(d.value,-6),'mm/dd/yyyyhh24miss')

old 9: and to_date('&&startd'||substr(d.value,-6),'mm/dd/yyyyhh24miss') +1 - .00000001

new 9: and to_date(''||substr(d.value,-6),'mm/dd/yyyyhh24miss') +1 - .00000001

and to_date(''||substr(d.value,-6),'mm/dd/yyyyhh24miss') +1 - .00000001