# Postgres error 22007: invalid input syntax for type timestamp / date

> Text could not be parsed as a date or time.

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

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

## Causes

- Ambiguous or locale-specific formats such as 08/10/2026 when DateStyle expects a different order.
- Empty strings sent for a timestamp column instead of null.

## Fixes

- Send ISO 8601 (2026-10-08T14:30:00Z) from the app.
- Convert empty strings to null before writing.
- Use to_timestamp(text, format) when you must parse a fixed custom format.