-
Notifications
You must be signed in to change notification settings - Fork 7
Expand file tree
/
Copy pathlast_monday_month.sql
More file actions
10 lines (10 loc) · 1.08 KB
/
last_monday_month.sql
File metadata and controls
10 lines (10 loc) · 1.08 KB
1
2
3
4
5
6
7
8
9
10
select case when to_char(last_day( sysdate ),'D') = 2 then (select to_char((last_day(sysdate)),'DD-MON-YYYY') from dual)
when to_char(last_day( sysdate )-1,'D') = 2 then (select to_char((last_day(sysdate)-1),'DD-MON-YYYY') from dual)
when to_char(last_day( sysdate )-2,'D') = 2 then (select to_char((last_day(sysdate)-2),'DD-MON-YYYY') from dual)
when to_char(last_day( sysdate )-3,'D') = 2 then (select to_char((last_day(sysdate)-3),'DD-MON-YYYY') from dual)
when to_char(last_day( sysdate )-4,'D') = 2 then (select to_char((last_day(sysdate)-4),'DD-MON-YYYY') from dual)
when to_char(last_day( sysdate )-5,'D') = 2 then (select to_char((last_day(sysdate)-5),'DD-MON-YYYY') from dual)
when to_char(last_day( sysdate )-6,'D') = 2 then (select to_char((last_day(sysdate)-6),'DD-MON-YYYY') from dual)
else '00'
end last_monday_month
from dual