Hi,
We have some bad data in a table showing year as 0217 rather than 2017
was looking to update by adding 1800 years to it so shows 2017 but getting error ORA-01873 "leading precision of the interval is too small" error
using
date_field, date_field + INTERVAL '1800' YEAR
can do
date_field, date_field + INTERVAL '10' YEAR and no error but if try add say 100 or 1800 get error.
oracle 11.2.0.3 and date datatype
example bad 26/07/0217 18:00:00
How can we add 1800 years to the date using year?
Can use add_months(date_field,21600) as workaround.
Thanks