Week numbers in Oracle DB

To get the current ISO 8601 week number in Oracle DB, use the following code snippet:

SELECT TO_CHAR(SYSDATE, 'IW') FROM DUAL;

* Ensure your system or application regional settings are set to follow ISO 8601 standards (weeks start on Monday) if the output varies.