This discussion is archived
1 Reply Latest reply: Dec 13, 2012 2:32 AM by Stew Ashton RSS

getting start and end date for the week starting on monday

979242 Newbie
Currently Being Moderated
i want monday as my week start and sunday as my end of the week,

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

this query will fail

can you suggest me the solution for that