CODEWITHSUNDEEP
sqloracle-databaseora-01858
kiran6
kiran6

Reputation: 1295

ORA-01858: a non-numeric character found where a digit was expected

create table fb_post (    
post_id int primary key,    
post_author varchar(5),    
post_wall_id varchar(5),    
post_date date,    
post_location varchar(50),    
foreign key (post_author) references fb_user(fb_id),    
foreign key (post_wall_id) references fb_wall(wall_id));

insert into fb_post
values(1201,'F2','W6',to_date('Oct-02-07 09:11:17','mon-dd-yy hh24:mi:ss'),'Gonzales, LA, United States');

insert into fb_post
values(1202,'F3','W8'   ,to_date('Oct-02-07 01:31:39','mon-dd-yy hh24:mi:ss'),'Gonzales, LA, United States');

insert into fb_post
values(1203,'F12','W14',to_date(' Oct-02-07 09:10:54, 'mon-dd-yy hh24:mi:ss'),'Pasadena,LA,United States');

The first and third rows are being created but the second one fails saying,

ORA-01858: a non-numeric character found where a digit was expected

Upvotes: 0

Views: 714

Answers (1)

elixenide
elixenide

Reputation: 44851

You're missing a ' after 09:10:54:

insert into fb_post
values(1203,'F12','W14',to_date(' Oct-02-07 09:10:54', 'mon-dd-yy hh24:mi:ss'),'Pasadena,LA,United States');

Upvotes: 2

Related Questions