Help

Posted in 1995

Hong T An — 21 Mar 1995 04:51:35 GMT — source: Informix-list mailing list archive (1991-1998)

I am using Informix-SQL V4.0. I waant to know how the datatype DATETIME is stored by the datadase. Is it a string? For mytime DATETIME(15:30) HOUR TO MINUTE, is it a string of five characters 15:30. Or is it stored as integer I am using esql to retieve data in database, then assign the value to host variable(in C). How about DATATIME(1995-3-19 23:59:37.03) YEAR TO FRACTION. Thanks