Re: Getting epoch in dates

Posted in 1998

Dilip Kikla — Mon, 23 Mar 1998 12:11:49 -0800 — source: Informix-list mailing list archive (1991-1998)

Informix stores dates in a Gregorian format, data type integer. Here 1 represents 1/1/1900. Hence popping a 0 should display 12/31/1899. Do you explicitely insert NULL or a "" for a date value? Dilip Kikla jparker@epsilon.com wrote: > > My colleague here (jshah) is using esql/c to pop values into a date column, > when looking at the value after he's popped in a NULL it is 12/31/1899. I > don't remember anything about esql/c except how to spell it. Is there some > kind soul... > > adv(thanks)ance > > cheers > j.