ORA-01830

From: Irfan Baig <irfan_at_abstractedge.com>
Date: Fri, 27 Jul 2001 15:27:59 GMT
Message-ID: <20010727.112328.1494613810.30901@irf.local>

Oracle 8.1.6 on Red Hat Linux 6.0.
The SQL for the record below was generated from a db on the same oracle server version, except on an HP machine. I tried to add the record to my Linux server, but got the error below.

Furthermore, if I remove the time segment from the SQL below
(i.e. '28-SEP-2000 13:04:14' --> '28-SEP-2000'), the record
gets added without any problem. The field TRAN_DATE is of type DATE. Would appreciate any help.

--
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SQL> INSERT INTO COMPANY.CODE
  2  (CODE, TRAN_DATE)
  3  VALUES 
  4  (9516709,'28-SEP-2000 13:04:14')
  5  /


(9516709,'28-SEP-2000 13:04:14')

         *
ERROR at line 4:
ORA-01830: date format picture ends before converting entire input string

Received on Fri Jul 27 2001 - 10:27:59 CDT