nadamien commented on issue #45857: URL: https://github.com/apache/superset/issues/45857#issuecomment-6566380880
Tested on Oracle 19.19 across the 2025 - 2026 year boundary: - TRUNC(d, 'WW'): week start moves from Wed (2025) to Thu (2026), and 31 Dec 2025 is a 1-day week (30 Dec -> 24 Dec, 31 Dec -> 31 Dec, 1 Jan -> 1 Jan). - TRUNC(d, 'IW') : always Monday (29 Dec covers 29 Dec – 4 Jan), with the same result under NLS_TERRITORY` AMERICA and GERMANY. - TRUNC(d, 'D') : Sunday under AMERICA, Monday under GERMANY, so it depends on session settings. 'IW' is the right choice. LGTM from the Oracle side. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
