The below are my specid and changedate column having timestamp(9) values
I have another table and I am trying to load the data from this table a to another table b. I am getting error
insert into spectable select specid,cast(changedate as timestamp(0)) from spec;
I am getting ORA-25137: Data value out of range error in oracle.
Is this because of the reason the oracle is not able to understand 6870000 and considering data out of range.
We are using Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Please appreciate your help
Regards,