Re: Date String Conversion error

Posted in 1997

Rodney R. Fredette — Fri, 24 Jan 1997 00:02:48 GMT — source: Informix-list mailing list archive (1991-1998)

date datatypes only contain month/day/year valus. Datetime data types support more precission. Your example will only work if subscription_date is datetime or if the data value is "1997-01-11". In article <32E4F72E.1936@www.kaplan.com>, chen@www.kaplan.com says... > >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?? > >Thanks. >-- >Ernest Chen, Kaplan Interactive >mailto:chen@www.kaplan.com >mailto:Ernest@www.kaplan.com >mailto:Ernest_Chen@www.kaplan.com >