RE: I have the error: "1210: Date could not be converted to month/day/year format"
Hi,
I'm sorry but I don't know Informix very well, How can I do an oncheck ?
Thank you.
-----Original Message-----
From: owner-informix-list@iiug.iiug.org
[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of
mars1972@my-deja.com
Sent: mercoled' 14 giugno 2000 21.20
To: informix-list@iiug.org
Subject: RE: I have the error: "1210: Date could not be converted to
month/day/year format"
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.
oncheck -cD <database>:<table> to check consistency of data.
oncheck -cI <database>:<table> to check indexes.
Both of these lock the table exclusively, so do it during maintenance.
In article <8i9vsm$6cm$1@news.xmission.com>,
<giovanni.guarino@cogitonet.com> wrote:
>
> Hi,
> I'm sorry but I don't know Informix very well, How can I do an oncheck
?
> Thank you.
>
> -----Original Message-----
> From: owner-informix-list@iiug.iiug.org
> [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of
> mars1972@my-deja.com
> Sent: mercoled' 14 giugno 2000 21.20
> To: informix-list@iiug.org
> Subject: RE: I have the error: "1210: Date could not be converted to
> month/day/year format"
>
> 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.
>
>
--
# unrm /
ksh: unrm: not found
# man cpio
Sent via Deja.com http://www.deja.com/
Before you buy.