ORA-1878 when using from_tz
We need to upload to another system the birth dates.
The birth dates are entered in the database without time meaning they are saved with time 00:00.
Now I need to convert this to UTC. This is a requirement.
However I'm getting ORA-1878.
Here is one example.
SELECT from_tz(CAST(To_Date('03.04.1977 00:00:00', 'dd.mm.yyyy hh24:mi:ss') AS TIMESTAMP), 'Asia/Nicosia') AT TIME ZONE 'UTC' AS date_utc
FROM dual
I understand that this is happening because '03.04.1977 00:00:00' does not exist since the time was moved 1 hour that day. It was never 12 o'clock on 03.04.1977 becasue of the time change.
0