Oninit cdi / Archive
Talk to an expert →

RE: I have the error: "1210: Date could not be converted to month/day/year format"

Posted in 2000

Topics: SQL Development & Query Writing, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration

Giovanni Guarino — — source: Informix-list mailing list archive (1991-1998)

The field is a date. I run the select statment from dbaccess. -----Original Message----- From: Carlos Benjamin [mailto:benj@firstlinux.net] Sent: mercoled' 14 giugno 2000 18.26 To: giovanni.guarino@cogitonet.com; informix-list@iiug.org Subject: Re: I have the error: "1210: Date could not be converted to month/day/year format" --- "Giovanni Guarino" <giovanni.guarino@cogitonet.com> > wrote: > >Hi, > >when I run the select statement: > >select <field> from <table> where <field> > '01/02/99' > >I have the error: "1210: Date could not be converted to month/day/year >format" > >Can you help me ? > >Thank you. > >G.G. As long as your <field> is a date field that should work. Are you running this in dbaccess, isql, 4gl code....? == carlos Maintainer of the procrastinator's FAQ Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net

↪ replying to Giovanni Guarino
mars1972@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

You may have bad data in the table. Try doing an oncheck. In article <8i8cvh$pi9$1@news.xmission.com>, <giovanni.guarino@cogitonet.com> wrote: > > > The field is a date. > I run the select statment from dbaccess. > > -----Original Message----- > From: Carlos Benjamin [mailto:benj@firstlinux.net] > Sent: mercoled' 14 giugno 2000 18.26 > To: giovanni.guarino@cogitonet.com; informix-list@iiug.org > Subject: Re: I have the error: "1210: Date could not be converted to > month/day/year format" > > --- "Giovanni Guarino" <giovanni.guarino@cogitonet.com> > wrote: > >Hi, > > >when I run the select statement: > >select <field> from <table> where > <field> > '01/02/99' > >I have the error: "1210: Date could not be converted > to month/day/year >format" > >Can you help me ? > >Thank you. > >G.G. As > long as your <field> is a date field that should work. Are you running this > in dbaccess, isql, 4gl code....? > > == > carlos Maintainer of the procrastinator's FAQ Well, maybe tomorrow I will > be. > > _____________________________________________________________ > Want a new web-based email account ? ---> http://www.firstlinux.net > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Giovanni Guarino
Leonids.Voroncovs@dati.lv — — source: Informix-list mailing list archive (1991-1998)

Giovanni Guarino wrote: > The field is a date. > I run the select statment from dbaccess. > > select <field> from <table> where > <field> > '01/02/99' I have the error: "1210: Date could not be converted > to month/day/year >format" Check Your environment: DB_LOCALE, CLIENT_LOCALE, DBDATE.

Glossary