I did an dbexport on a database using INFORMIX-OnLine Version 7.23.UC4.
When I attempted to dbimport the database I receive the following error:
-1218 String to date conversion error.
The input to the rstrdate() function does not properly represent a
date: either it has nondigits where digits are expected, an unexpected
delimiter, or numbers that are too large or are inconsistent.
Does anyone have an idea of what could actually be causing this problem? The date data in the
columns specified as date column look fine?
TIA
Cheryl L. Kendricks
Sr. DBA H.E. Butts Grocery
San Antonio, Texas
↪ replying to KENDRICKS.CHERYL@notes.heb.com
In article <8kd264$71a$1@news.xmission.com>,
KENDRICKS.CHERYL@notes.heb.com writes
>
>I did an dbexport on a database using INFORMIX-OnLine Version 7.23.UC4.
>
>When I attempted to dbimport the database I receive the following error:
>
>-1218 String to date conversion error.
>
>The input to the rstrdate() function does not properly represent a
>date: either it has nondigits where digits are expected, an unexpected
>delimiter, or numbers that are too large or are inconsistent.
>
>Does anyone have an idea of what could actually be causing this problem? The
>date data in the
>columns specified as date column look fine?
>
>TIA
>Cheryl L. Kendricks
>Sr. DBA H.E. Butts Grocery
>San Antonio, Texas
>
Check DBDATE is set the same on both machines.
--
David Williams