Date: 2025-09-21 10:59:08
Score: 3
Natty:
you need to use To_TIMESTAMP(observation_time, 'YYYY-MM-DD"T"HH24:MI:SS"Z"') format for oracle it doesn't understand TZ.
You can read this post about this exact error for more help
https://zayntheprogrammer.com/how-to/how-to-fix-ora-01843-and-ora-01858-errors-when-converting-utc-to-est-in-oracle
Reasons:
- Probably link only (1):
- Low length (0.5):
- No code block (0.5):
- Low reputation (1):