jw@pan.UUCP (Jamie Watson) (05/23/89)
What are people currently doing when they need to store and manipulate TIME values in Informix databases? I saw a posting about this a short time ago from someone else here in Switzerland (hi guys), and the answer from Informix was that some future release would have a time/date type included. That doesn't help current users much. The problems involved center around two major issues: - Querying. Generally users want to enter time values as hh:mm, or at least as hhmm. They certainly don't want to have to mentally convert to minutes (Hmm. How many minutes is 5:37PM?). - Performing arithmetic on these fields. Obviously, none of the SQL or 4GL operations such as "sum" work on values stored in hhmm format. jw