ORA-01841: (full) year must be between -4713 and +9999, and not be 0
Hello,
I've upgraded Oracle 19c from 19.21 to 19.25 and I've been struggling with timestamp precision.
I mean since this version any function/procedure with timestamp parameters seems to be use default precision 6 and I cannot overwrite that (by ODP.NET e.g new OracleParameter("i_EndTime", OracleDbType.TimeStamp, 7) or directly on DB)
Simple test
Make function with definition as below and run
CREATE OR REPLACE FUNCTION testmh (
p_data TIMESTAMP )
RETURN TIMESTAMP
IS
BEGIN
RETURN p_data;
END testmh;
select testmh(to_timestamp('12/31/9999 23:59:59.9999999','MM/DD/YYYY HH24:MI:SS.FF')) from dual;
It works on 19.21
But on 19.25 I've got