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 Picker week numbers vs first day of the week

kdpJun 26 2024

APEX 24.1

Date Picker configured as follows:

Which displays this:

Please note the week numbers.

The ISO week numbers, however start at Mondays (ISO-8601, as well as this Oracle documentation)

Running these queries:
select to_char(date'2024-06-23','IW') from dual;
select to_char(date'2024-06-24','IW') from dual;

or

select to_char(date'2024-06-23','WW') from dual;
select to_char(date'2024-06-24','WW') from dual;

Yield week number 25 and 26, not 26 in both cases.

I'm guessing the easiest thing to do is to put the Sundays at the end of the week. Or disable Weekends.
What are my options here?

This post has been answered by Karel Ekema on Jul 4 2024
Jump to Answer
Comments
Post Details
Added on Jun 26 2024
6 comments
561 views