Filter Records by Date Range in SQL

SELECT
  order_id,
  customer_name,
  order_date,
  total_amount
FROM
  orders
WHERE
  order_date BETWEEN '2023-01-01 00:00:00' AND '2023-01-31 23:59:59'
ORDER BY
  order_date ASC;

How it works: This query selects all order details from the `orders` table where the `order_date` falls within a specified range, from the beginning of January 1, 2023, to the end of January 31, 2023. The `BETWEEN` operator is inclusive of both the start and end values, making it ideal for filtering time-series data.