Path: utzoo!utgpu!utstat!jarvis.csri.toronto.edu!rutgers!ucsd!tut.cis.ohio-state.edu!mailrus!ncar!asuvax!romed!pete From: pete@romed.UUCP (Pete Rourke) Newsgroups: comp.databases Subject: Informix SQL time field Keywords: Informix time Message-ID: <520@romed.UUCP> Date: 9 Nov 89 21:50:47 GMT Organization: MicroAge Technical Support Lines: 20 Did I miss something in the manual, or is there no time field or time math in Informix SQL? I am trying to construct a database that can have a date and time entry to monitor the length of telephone calls, or delay in time for a database entry field. I'd also like to be able to do math on the time for reports. I suspect that a C language side car program could be done, but possibly there is some other alternative. Please direct information via email. If sufficient interest, I will post replies. Thanks in advance -- Pete Rourke ..texbell!romed!pete MicroAge Technical Support Group ..sun!sunburn!mcsitsg!pete Tempe, AZ ..ucsd!romed!pete (602) 968-3168 Ext 2273 ..asuvax!romed!pete