Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get last week's first and last day

4183458Feb 6 2020 — edited Feb 6 2020

Hi All,

I need to get date of previous week's first and last day. For example,

today is 2/6/2020 (Thursday), I need to write a query, which gives me  01/26/2020 and 02/01/2020 as output.

if today is 2/9/2020 (Sunday) it should return me 02/02/2020 and 02/08/2020

PS. Sunday is the first day and Saturday is the last day of the week.

Can someone help me.... giving -7 to sysdate is not working as it is dynamic one.

Comments
Post Details
Added on Feb 6 2020
2 comments
9,039 views