Deviopath › PostgreSQL

Orders in March 2026

Easy · Dates

Dates are compared like numbers, and you write them as text in YYYY-MM-DD form: '2026-03-01'. A safe way to pick a whole month is "on or after the 1st, and before the 1st of the next month".

Return the id, ordered_on and total of every order placed in March 2026.

Next: Year of Hiring