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!

Date Format X Axis / Apex 20.2.0.00.20

McsearcherJan 20 2022

I've just started working with Graphs in Apex. For this example i created a table with 2 columns, Value and date. value :
1 01.01.2022 17:00:00
2 03.01.1022 17:00:00
3 02.01.2022 17:00:00
And thats the way i would like to see it.
I created a BAR Chart Type / Orientation vertical
Column Mapping Series Name /Label/Value all to Value.
SQL in Series1 : select value, date from AXISTEST
From several other Questions i found:
-Shared Component/Application Definition/Globalization : Values are ignored, when different Values in the Application defined.
-Settings of Content Body "Time Axis Enabled"
-choose DateTime - Medium on x Axis and set a Mask in Unicode CLDR (which is not really clear to me) i set dd MM y hh:mm:ss
As Result i get
01.01.2001 12:00:00
01.02.2001 12:00:00
01.03.2001 12:00:00
This seems to me that day is month, although the mask is dd MM.
Has anybody an Idea what i'm doing wrong?
Thanks in advance.
Markus

This post has been answered by Mcsearcher on Jan 24 2022
Jump to Answer
Comments
Post Details
Added on Jan 20 2022
7 comments
1,797 views