As of Oracle 11g, yes. The only viable region agnostic alternative that I've seen is as follows:SELECT *FROM mytableWHERE MOD(TO_CHAR(my_date, 'J'), 7) + 1 IN (6, 7);