Hi Apex developpers,
Under APEX 24.1 (in French) in the code editor I have a nice SQL command :
select sum(a.duree) "Durée", c.TACHE "Tâche"
from RH_ACTIVITE_EFFECTUEE a, RH_TACHE c
where a.TACHE_EFFECTUEE_ID = c.ID
and a.EFFECTUEE_LE between to_date (:P4_DU, 'DD/MM/YYYY') and TO_DATE (:P4_AU, 'DD/MM/YYYY')
group by c.tache
order by TACHE
When run, it displays a windows asking the values of the bind variables :P4_DU and P4_AU:

All fine. When I run again the SQL command, the windows shows strange characters instead of the dates:

Is it possible to repair this little problem ?
Best regards.