1 Reply Latest reply: Dec 13, 2012 4:32 AM by Stew Ashton RSS

    getting start and end date for the week starting on monday

    979242
      i want monday as my week start and sunday as my end of the week,
      then

      select trunc(sysdate, 'DAY')+6 from dual;

      this query will fail

      can you suggest me the solution for that