Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center