Re: Help

Quoting Hong T An... } } 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. } DATETIMEs (and INTERVALs) are stored internally as C structures. Take a look at $INFORMIXDIR/incl/datetime.h for more specifics. DAS -- Dave Snyder @ Bell Atlantic - Philadelphia, PA WORK: ddx85qr@boots.bell-atl.com HOME: dave@das13.snide.com