Oracle SQL: How to Get Last Saturday of the Month🔥
This SQL Query will show you how to get last Saturday of the month. You can provide any date of the month.
You can find any weekday from below query by changing 'SAT' to day of your choice
select next_day(last_day(to_date('01-Aug-2023')) - 7,'SAT') from dual