# Postgres error 22008: date/time field value out of range

> The text parsed but the value is impossible, such as month 13 or 30 February, or day and month were swapped.

Source: https://scribase.com/postgres-errors/22008

SQLSTATE class: Data Exception. Over PostgREST/supabase-js this maps to HTTP 400.

## Causes

- A day-first date read with a month-first DateStyle (13/02/2026).
- Invalid dates generated by string concatenation.

## Fixes

- Use ISO 8601 dates.
- Build dates with make_date(year, month, day) or make_timestamptz instead of strings.