Hi
I am uisng APEX 19.2. I have a chart with a simple select :
select TO_DATE(date_prelevement, 'DD/MM/YYYY') "Date du prélèvement", to_number (replace (VALEUR_RESULTAT_ANALYSE, '.', ',')) "Valeur"
from sq_aesn
where NOM_STATION = :P11_NOM_STATION
and NOM_PARAMETRE = :P11_NOM_PARAMETRE
order by 1
I want the date to be formatted like this : 'DD/MM/YYYY'. But in the graph and in the tooltip, it appears like this (the american format) :
Instead of "Groupe : 2018-01-10T00:00:00" I would like to to display as "Date : 10/01/2018".
Second thing is that the date in the X axis appear truncated and in the american format. Instead of "2018-01-1..." I would like to appear complete and in the french format like this : "10/01/2018"
I have not seen where in the parameters I could do this.