Re: DATETIME fraction missing

} From: Sood_Niraj/SO@instru.fi } Subject: DATETIME fraction missing } } We have a customer running Informix OnLine 7.01 on a HP800, = } } HP-UX 10.01. } } Their problem is that although a table field is defined as containing a } DATETIME including fractions, the fraction field is always 000. Output } example : } name_fld time_fld = } } a1 1996-09-27 15:53:27.000 } } I have been able to reproduce this problem on our HP800 running } HP-UX 9.01 and Informix OnLine 6. However, on another Unix host, } running SCO Unix 5 and OnLine 5.06, fractions do return the time } expressed as 1/1000 s. Output example : } name_fld time_fld } a1 1996-09-27 15:53:27.260 } } The SQL statements used to create the table, insert a row and selecting } it: } create table time (name_fld char(4), time_fld DATETIME YEAR TO } FRACTION); } insert into time_fld (name_fld,time_fld) values ("a1", CURRENT); } select * from time_fld; Do you still get the same results by setting the USEOSTIME parameter in the $ONCONFIG file to 1 ? -- Rajiv Jhaveri( rajivp@qsun2.ho.att.com) DBA