I’m getting an error when reading an Oracle database on the Datetime.
Error converting from OCI datetime to C character string : `ORA-01805: possible error in date/time operation'
These are my current installs
Question
Error with reading oracle datetime.
+61- Evangelist
https://docs.oracle.com/en/error-help/db/ora-01805/?r=26ai
ORA-01805 - possible error in date/time operation
Cause - The timezone files on client and server do not match. Operation can potentially result in incorrect results based on local timezone file.
Action - Please ensure client and server timezone versions are same.
So it probably has to do with differences in timezone versions. Unfortunately I'm not sure how to proceed from there…
Update: I also found this: https://stackoverflow.com/questions/72604577/sql-query-returns-ora-01805-possible-error-in-date-time-operation-error, which may be of help.