"not a valid month"

I have an insert statement in Oracle

INSERT INTO TABLE1 (..., ...,...,CREATED_DATE, CREATED_BY..)
     VALUES(........L,'2012-01-27 11:42:04.830','JOHN','N')
Error report:
SQL Error: ORA-01843: not a valid month
01843. 00000 -  "not a valid month"
*Cause:    
*Action:


Date_type of
CREATED_DATE is      TIMESTAMP(6)            

How to fix this issue?
wasabi3689Asked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Never reply on implicit data type conversions.

Always to data conversions explicitly:

to_timestamp('2012-01-27 11:42:04.830','YYYY-MM-DD HH24:MI:SS.FF')
0
 
wasabi3689Author Commented:
I have this error by using

to_timestamp('2012-01-27 11:42:04.830','YYYY-MM-DD HH24:MI:SS.FF')

Error report:
SQL Error: ORA-00947: not enough values
00947. 00000 -  "not enough values"
*Cause:    
*Action:
0
 
slightwv (䄆 Netminder) Commented:
Post your complete statement.  You are missing a column or 10 between the insert and the select.

from: http://ora-00947.ora-code.com/
INSERT INTO EMP(EMPNO,ENAME) VALUES('JONES')



You can test just the to_timestamp with:
select to_timestamp('2012-01-27 11:42:04.830','YYYY-MM-DD HH24:MI:SS.FF')  from dual;
0
 
wasabi3689Author Commented:
never mind. I figure out
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.