Filter by year or month using EXTRACT

Question

Accepted Answer

EXTRACT(YEAR FROM ...) = 2024 AND EXTRACT(MONTH FROM ...) = 1 filters to January 2024. Order 1 is in 2023 (wrong year). Order 4 is in February (wrong month). Orders 2 and 3 are both in January 2024. An alternative that uses an index better: WHERE order_date >= '2024-01-01' AND order_date < '2024-02-01' - EXTRACT on a column usually prevents index use.