Skip to Main Content

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!

How to display weeks in a graph ?

Christian PitetFeb 11 2022

Hi,
Under APEX 21.2 I have a graph and I want to show weeks on the X axis number. I use the Unicode CDLR symbol "W" as described in the documentation of CDLR Unicode :
Unicode Locale Data Markup Language (LDML) Part 4: Dates (0 Bytes)But it displays "W" instead of the week.
Capture.PNGMy select is simple :

select trunc(date1, 'IW') "Semaine", sum(KM_JOURNALIER_VAE) "Km hebdomadaire VAE"
from BO_MAIN_COURANTE
group by trunc(date1, 'IW');

How to display weeks ?
Best regards.
Christian

Comments
Post Details
Added on Feb 11 2022
2 comments
183 views