Re: Date Conversion Error 1218
Thank you very much! This was truly the problem.
ccremid <ccremid@saadev.saa.noaa.gov> on 05/07/98 01:07:36 PM
To: KENDRICKS CHERYL <KENDRICKS_CHERYL@NOTES45.HEB.COM>
cc: informix-list@iiug.org (bcc: KENDRICKS CHERYL/HEB45)
Subject: Re: Date Conversion Error 1218
Check the DBDATE environment variable used at the time
of dbexport and see if its value matches the one that
you are using at the time of dbimport.
Hope this helps
Tino
KENDRICKS CHERYL wrote:
>
> 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