Skip to main content
Question

Error with reading oracle datetime.

  • Jan 7, 2026 4:33 PM UTC
  • 1 reply
  • 96 views

spud
Contributor
Forum|alt.badge.img+1

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

 

1 reply

geomancer
Evangelist
Forum|alt.badge.img+71
  • Evangelist
  • Jan 7, 2026 4:59 PM UTC

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.