when dbimport appear error code 1262

Happy Day, I wonder what is this error code for 1262, when i doing the dbimport it appear this code. anyone how to solve this error code. Appreciate if anyone know it. -1262 Non-numeric character in datetime or interval. The form of a DATETIME or INTERVAL literal is very limited. One may contain only decimal digits and the allowed delimiters: the hyphen between year, month, and day numbers; the space between day and hour; the colon between hour, minute, and second, and the decimal point between second and fraction. Any other characters, or these characters in the wrong order, will be detected as an error. Thanks Regards, LIM

Jim, The Datetime field in the table has a value of a different data type (invalid date time). If you know the table and the load file, you can try loading the table using dbload/load, it would display the line where the invalid data is. Rectify the data and try again. Hope this helps. Thank you, Kannan Thirugnanam -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of James Lim Sent: Saturday, March 19, 2005 10:45 PM To: ids@iiug.org Subject: when dbimport appear error code 1262 [4562] Happy Day, I wonder what is this error code for 1262, when i doing the dbimport it appear this code. anyone how to solve this error code. Appreciate if anyone know it. -1262 Non-numeric character in datetime or interval. The form of a DATETIME or INTERVAL literal is very limited. One may contain only decimal digits and the allowed delimiters: the hyphen between year, month, and day numbers; the space between day and hour; the colon between hour, minute, and second, and the decimal point between second and fraction. Any other characters, or these characters in the wrong order, will be detected as an error. Thanks Regards, LIM