Oninit cdi / Archive
Talk to an expert →

Re: Date Conversion Error 1218

Posted in 1998

Peter Lancashire — — source: Informix-list mailing list archive (1991-1998)

David Williams wrote: > > 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 Yes. Even Informix mangled the demo database creation script this way once by forgetting to set DBDATE. They assumed that the whole world works the way they do in the USA and never used DBDATE... -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/

Related threads