ORA-01861: literal does not match format string
Hello,
I have a query made in oracle 18C on a sql server base made via dblink and it works as expected.
I'm performing a migration to 19C and I get the following error:
ORA-01861: literal does not match format string
01861. 00000 - "literal does not match format string"
*Cause: Literals in the input must be the same length as literals in
the format string (with the exception of leading whitespace). If the
"FX" modifier has been toggled on, the literal must match exactly,
with in the extra whitespace.
*Action: Correct the format string to match the literal.
Where the field that emits an error is the DataPayment of type datetime2 within the sql server.