Here are the examples of Oracle SQL queries to exclude weekends from a date range.
Suppose you are querying a table to get the data for a particular date range, and you want to exclude the weekends. Below is an example.
Exclude Weekends in Oracle SQL Using to_char(date, 'DY') Function
The following SQL query will get the last 30 days' sales data, but weekends (Saturdays and Sundays) are excluded:
SELECT * FROM sales_orders WHERE TO_CHAR(order_date, 'DY') NOT IN ('SAT', 'SUN') and trunc(order_date) >= trunc(sysdate) - 30;
The data output will include all days except Saturdays and Sundays.
Leave a comment