PostgreSQL error code
PostgreSQL error 22009
22009 is the SQLSTATE PostgreSQL reports for invalid time zone displacement value, in class 22, Data Exception.
| SQLSTATE | 22009 |
|---|---|
| Condition name | invalid_time_zone_displacement_value |
| Class | 22 — Data Exception |
Reproduce it, then fix it
Real UTC offsets run from -12 to +14 hours, and PostgreSQL accepts up to ±15:59. An offset of +25 usually means the time and offset were put together wrongly. Run the broken query to see the error, then switch to the fixed one. Edit either freely; every run is rolled back.
SELECT '2024-06-01 10:00+25'::timestamptz;
SELECT '2024-06-01 10:00+02'::timestamptz;