SQL & PL/SQL

Hi,

version 10.2.0.4

using sql below get ORA-01036 - illegal variable name/number

v_sql := q'[
select to_date('05/10/2020 22:22:43','DD/MM/YYYYHH24:MI:SS')
from dual]';

            dbms\_output.put\_line(v\_sql);    

want to have dynamic sql which has dates such as this - had hoped to use the q delimiter for this but doesn't seem to like.

How can we achieve this with q delimiter- didn't really want to have to use quotes like below a quite alot of dates in the sql concerned.

v_sql := '
select to_date(''05/10/2020 22:22:43'',''DD/MM/YYYYHH24:MI:SS'')
from dual';

            dbms\_output.put\_line(v\_sql);    

Thanks