Re: Inserting into a date field.

Posted in 1997

Chris Dornsife — Fri, 03 Oct 1997 09:42:09 -0700 — source: Informix-list mailing list archive (1991-1998)

use the full year with quotes. try '10/01/1997' > Terron Wright (twright@inbrand.com) wrote: > : I am trying to insert data into a date field and I have not been able to > : figure out the correct string for inserting 10/01/97. I have tried > : 100197 and when I do a select it comes out at July 15, 4558. I can today > : and it puts in today date correctly. Does anyone have a solution.