Oninit cdi / Archive
Talk to an expert →

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

Posted in 2000

Topics: SQL Development & Query Writing

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

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.

↪ replying to Giovanni Guarino
Rudy Fernandes — — source: Informix-list mailing list archive (1991-1998)

The DBDATE environment variable must be set to MDY2/ or DMY2/ (depending on whether your '01/02/99' is 2nd Jan 99 or 1st Feb 99). Rudy Giovanni Guarino 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.