This message was deleted.
# ask-community-for-troubleshooting
s
This message was deleted.
k
A message from kapa.ai
It seems like you are encountering a schema validation error related to the
timestamp without timezone
column in your Postgres source. The error message indicates that the provided date-time value is considered invalid. Airbyte has five temporal types:
date
,
timestamp_with_timezone
,
timestamp_without_timezone
,
time_with_timezone
, and
time_without_timezone
. These are represented as strings with specific
format
(either
date
or
date-time
) [source](https://docs.airbyte.com/understanding-airbyte/supported-data-types). However, JSON schema does not have a built-in way to indicate whether a field includes timezone information. To resolve this ambiguity, sources producing timestamp-ish fields should choose either
timestamp_with_timezone
or
timestamp_without_timezone
(or time with/without timezone) using the
airbyte_type
field [source](https://docs.airbyte.com/understanding-airbyte/supported-data-types). Please ensure that your source schema is correctly configured with the appropriate
airbyte_type
for your timestamp column. If you still encounter issues, consider checking the data in your source table to ensure that it conforms to the expected format.