Re: datetime insertion problems

Posted in 1995

Kerry Sainsbury — Mon, 25 Sep 1995 20:34:16 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <43uptf$rg8@news.informix.com>, > Stephen C. Dickey (scdickey@corbsys.com) wrote: > : I am trying to insert data into a field defined as DATETIME <YEAR to SECOND> > : and am trying to insert the following value: > > : '1995-08-17 08:00:00' > > : It used to work in OnLine verison 7.1 but does not seem to work in OnLine > : version 5.x. Is this a valid value for insetion under version 5? If not how > : do I insert the data in a correct format? A guess: Is DBDATE defined correctly? Try swapping month and day. ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.2 Mar 95 Quanta Systems, Auckland | kcbbs.gen.nz:/informix/informix.[faq|apx] New Zealand. Work: +64 9 377-4473 | mathcs.emory.edu:/pub/informix/faq/ " " Home: +64 9 279-3571 | http://www.garpac.com/informix.html