Re: Date String Conversion error

Posted in 1997

Irwin Goldstein — 22 Jan 1997 22:17:04 GMT — source: Informix-list mailing list archive (1991-1998)

Ernest Chen <chen@www.kaplan.com> wrote in article <32E4F72E.1936@www.kaplan.com>... > The document for Online Server v7.1 says I can do this: > > insert into mytable (subscription_date, email) > values('1997-01-11 08:45', "hello");> > subscription_date has a data type of 'date' > > I received date string conversion error, can anybody help?? The literal you specified is for a "datetime year to minute", not a "date". A "date" has no HH:MM component. HTH -- Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com