DATETIME fraction missing
--openmail-part-001821f9-00000002 Content-Type: text/plain; charset=US-ASCII; name="DATETIME" Content-Transfer-Encoding: quoted-printable FROM : Henrik Rosas Instru Data phone +358-9-58446421 fax +358-9-7573515 henrik.rosas@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; --openmail-part-001821f9-00000002 Content-Type: application/rtf; name="DATETIME" Content-Transfer-Encoding: base64 {\\rtf1\\ansi\\deff0{\\fonttbl{\\f0\\froman Tms Rmn;}{\\f1\\froman Courier New;}}{\\colortbl\\red0\\green0\\blue0;\\red0\\green0\\blue255;\\red0\\green255\\blue255;\\red0\\green255\\blue0;\\red255\\green0\\blue255;\\red255\\green0\\blue0;\\red255\\green255\\blue0;\\red255\\green255\\blue255;\\red0\\green0\\blue127;\\red0\\green127\\blue127;\\red0\\green127\\blue0;\\red127\\green0\\blue127;\\red127\\green0\\blue0;\\red127\\green127\\blue0;\\red127\\green127\\blue127;\\red192\\green192\\blue192}{\\info{\\creatim\\yr1996\\mo9\\dy30\\hr16\\min37\\sec24}{\\version1}{\\vern197985}}\\paperw12240\\paperh15840\\margl720\\margr2834\\margt1440\\margb1440\\deftab720\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 FROM : Henrik Rosas}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 Instru Data}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 phone +358-9-58446421}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 fax +358-9-7573515}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 henrik.rosas@instru.fi}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 Subject: DATETIME fraction missing}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 We have a customer running Informix OnLine 7.01 on a HP800, }{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 HP-UX 10.01.}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 Their problem is that although a table field is defined as containing a }\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 DATETIME including fractions, the fraction field is always 000. Output }\\ql{\\f1\\fs20\\cf0\\up0\\dn0 example :}{\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0 name_fld time_fld }{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 a1 }{\\f1\\fs20\\cf0\\up0\\dn0\\tab}{\\f1\\fs20\\cf0\\up0\\dn0 1996-09-27 15:53:27.000}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 I have been able to reproduce this problem on our HP800 running }\\ql{\\f1\\fs20\\cf0\\up0\\dn0 HP-UX 9.01 and Informix OnLine 6. However, on another Unix host,}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 running SCO Unix 5 and OnLine 5.06, fractions do return the time }\\ql{\\f1\\fs20\\cf0\\up0\\dn0 expressed as 1/1000 s. Output example :}{\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0 name_fld time_fld}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 a1 1996-09-27 15:53:27.260}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 The SQL statements used to create the table, insert a row and selecting }\\ql{\\f1\\fs20\\cf0\\up0\\dn0 it:}{\\par}\\pard\\ql\\li0\\fi0\\ri30{\\f1\\fs20\\cf0\\up0\\dn0 create table time (name_fld char(4), time_fld DATETIME YEAR TO }\\ql{\\f1\\fs20\\cf0\\up0\\dn0 FRACTION);}{\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0 insert into time_fld (name_fld,time_fld) values ("a1", CURRENT);}{\\par}\\pard\\ql\\li0\\fi0\\ri28{\\f1\\fs20\\cf0\\up0\\dn0 select * from time_fld;}{\\par}\\pard\\ql\\li0\\fi0\\ri30} --openmail-part-001821f9-00000002--