ORA-01830: date format picture ends before convert

• • Reply

  17 years ago

  by kumsi

  Kris

  USA, United States

  Joined 17 years ago

  Hi Folks,
  Being struggling with this error. Any idea whats wrong in this. It gives me this error ORA-01830 when i execute this query.
  

  
  Thanks,
  Insert into CONTRACTT (CONTRACTID,BEGINDATE,ENDDATE,MARKETSERVICE,SERVICETYPE,CONTRACTTYPE,LOCATIONID,BUYERID,SELLERID,INTERNALREFERENCEID,TERMINATIONDATE,CONFIRMATIONLEVEL,FIXEDAMOUNTFLAG,CONFIRMED,PENDINGREQUESTBY,PENDINGPROFILE,SUBMITDATE,LASTUPDATEDDATE,FIXEDAMOUNTPATTERN) Values (680,'01/01/2002 4:00:00 AM','02/01/2002 4:00:00 AM',21,'NA','EBM',506,8,50010,'EXTREF680','','C','N','Y','','N','12/30/2001 4:00:00 AM','01/01/2002 3:00:00 AM','')
  

  
  Thanks in advance
  Kumsi

  Report abuse
• • Reply

  16 years ago

  by hurg

  hurg

  , United States

  Joined 16 years ago

  Quote:

  [1]Posted by kumsi on 11 Feb 2004 10:40 AM[/1]
  Hi Folks,
  Being struggling with this error. Any idea whats wrong in this. It gives me this error ORA-01830 when i execute this query.
  

  
  Thanks,
  Insert into CONTRACTT (CONTRACTID,BEGINDATE,ENDDATE,MARKETSERVICE,SERVICETYPE,CONTRACTTYPE,LOCATIONID,BUYERID,SELLERID,INTERNALREFERENCEID,TERMINATIONDATE,CONFIRMATIONLEVEL,FIXEDAMOUNTFLAG,CONFIRMED,PENDINGREQUESTBY,PENDINGPROFILE,SUBMITDATE,LASTUPDATEDDATE,FIXEDAMOUNTPATTERN) Values (680,'01/01/2002 4:00:00 AM','02/01/2002 4:00:00 AM',21,'NA','EBM',506,8,50010,'EXTREF680','','C','N','Y','','N','12/30/2001 4:00:00 AM','01/01/2002 3:00:00 AM','')
  

  
  Thanks in advance
  Kumsi
  

  
  

  
  Kumsi,
  

  
  Oracle does not understand that dates that you are passing to it. All date strings should be passed to Oracle using the TO_DATE function. In the example you provide, you would use:
  

  
  TO_DATE('12/30/2001 4:00:00 AM, 'MM/DD/YYYY HH:MI:SS AM')
  

  
  to encode all date values.
  

  
  

  
  Hurg

  Report abuse