We wish to determine the week of the year but out week is defined as starting on Monday and ending on Sunday. We are currently using a procedure like this:
FUNCTION schd_week_cx (v_date DATE)
vWeek VARCHAR2 (6);
But it returns the week based on the standard Saturday - Sunday criteria. It would be nice to avoid writing a lot of custom code, any ideas on an elegant solution would be greatly appreciated. We are under an extremely tight deadline.