This query returns the day of the week using the COMPATIBLE calendar:
Set session calendar = compatible; Sel day_of_week from Sys_Calendar.Calendar where calendar_date = date '2011-01-01'; day_of_week ----------- 1
This query returns the day of the week using the COMPATIBLE calendar:
Set session calendar = compatible; Sel day_of_week from Sys_Calendar.Calendar where calendar_date = date '2011-01-01'; day_of_week ----------- 1