Re: Date Conversion Error 1218
In article <6it9uk$i0q$1@news.xmission.com>, KENDRICKS CHERYL
<KENDRICKS_CHERYL@heb.com> writes
>
>
>
>
>Thank you very much! This was truly the problem.
>
>
Another one for the FAQ!
>
>
>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
>
>
>
>
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care