SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue with TIMESTAMP(0)

manojthakuriiMar 6 2022

Hello Team,

My DB Version is Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production.

I am having as shown below in a temp table.
The first column name is SPECID and second column is CHANGEDATE timestamp(9)

I am trying to insert records from temp table to spec table.

insert into spec select specid,cast(changedate as timestamp(0)) from temp;
I am getting ORA-25137: Data value out of range error
Please appreciate your help on this.

This post has been answered by manojthakurii on Mar 8 2022

Jump to Answer

Added on Mar 6 2022

#sql

10 comments

1,997 views

1 mention