H,, I'm trying to load some tables that has timestamp expressed in milliseconds, this results in an error:
psycopg.errors.DatetimeFieldOverflow: date/time field value out of range: "1692352800000"
HINT: Perhaps you need a different "datestyle" setting.
CONTEXT: COPY Device, line 1, column timestamp: "1692352800000"
How can I recover this? I don't mind to /1000 but I don't know how to do it, and if this would eventually solve the issue.
H,, I'm trying to load some tables that has timestamp expressed in milliseconds, this results in an error:
How can I recover this? I don't mind to /1000 but I don't know how to do it, and if this would eventually solve the issue.