RE: I have the error: "1210: Date could not be converted to mon
Posted in 2000
Topics: SQL Development & Query Writing, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration
To what value is the environment variable DBDATE set,
when you run this SQL through dbaccess?
If it is not set to "MDY2/", that could explain your error.
-----Original Message-----
From: Giovanni Guarino
To: benj@firstlinux.net; giovanni.guarino@cogitonet.com;
informix-list@iiug.org
Sent: 6/14/00 9:39 AM
Subject: RE: I have the error: "1210: Date could not be converted to
month/day/year format"
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