View Single Post
  #1 (permalink)  
Old January 8th, 2012, 06:42 AM
adhe2chazper adhe2chazper is offline
Registered User
Points: 13, Level: 1
Points: 13, Level: 1 Points: 13, Level: 1 Points: 13, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default ORA-01843 not a valid month

I create a table member with 8 fields, with idMember as primaryKey. Two among these fields is the field's date_of_birth and date_back that have same type, date.
But when I insert data into it, appears an error like this -> ORA-01843 not a valid month.
Previously when I didn't include a date field again, successfully. However when I include it, writing error ORA-01843 not a valid month.

I give the insert command like this:
insert into member values ​​('M102019', 'Adhe Nurcahya',.., to_date ('28-May-1992 ',' DD-MON-YYYY'),..., .. , to_date ('12-dec-2011 ',' DD-MON-YYYY '));

Anyone know why is this possible?
I'm confused, is there because in a record to_date there should be no more than 1??
Thank's..
Reply With Quote