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.