“I would like to request a new feature for Oracle SQL to support ISO week date standards, where the week starts on Monday (represented as 1) and ends on Sunday (represented as 7). This feature would be extremely useful for users who work with data that follows the ISO week date system.”
I did a query for today
SELECT TO_CHAR(SYSDATE, 'IYYY-"W"IW-D') AS iso_date FROM dual;
and got
2024-W19-2.
However, the correct answer should end with 1 because today is a Monday, and Monday is represented by 1 with ISO Week date.
https://en.wikipedia.org/wiki/ISO_week_date
I was born on a Monday, 2002-02-18. Therefore 1 day before was a Sunday and the number should be 7 for 2002-02-17. However,
SELECT TO_CHAR(DATE '2002-02-16', 'IYYY-IW-D') AS yearweek FROM DUAL;
yields
2002-07-7
I would like to be able to use the ISO week date numbering. In the current system, Sunday is 1 and Saturday is 7. In the ISO system, Monday is 1 and Sunday is 7.