BETWEEN inclusivity on date boundaries

Question

Accepted Answer

BETWEEN in SQL is always inclusive on both the lower and upper bounds. A row with order_date = '2024-06-01' passes, and so does a row with '2024-06-30'. This differs from the half-open interval convention you see in many programming languages. For TIMESTAMP columns, BETWEEN '2024-06-30' AND '2024-06-30' would only match the exact midnight instant, not the rest of the day.