APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date format in a graph

Christian Pitet.11 hours ago — edited 11 hours ago

Hi,

Under Oracle APEX 24.2.13, I am displaying a graph. But the date format displayed is not what I want. I want only the year and the month to be displayed like this “April 2025, May 2025, etc…)”.

Query is :

select count(DERNIERE_CONNEXION) as nombre_connexions,
      TRUNC(DERNIERE_CONNEXION, 'Month') as mois
 from TB_USERS
group by TRUNC(DERNIERE_CONNEXION, 'Month') 
order by TRUNC(DERNIERE_CONNEXION, 'Month')

Model is ‘MMM’.

Best regards.

This post has been answered by Anton Scheffer-Oracle on Feb 25 2026

Jump to Answer

Added 11 hours ago

7 comments

48 views