Re: time functions

Posted in 2003

Arthur Groen — Wed, 3 Dec 2003 15:48:26 +0100 — source: Usenet: comp.databases.informix

----- Original Message ----- From: "Mitja Udovc" <mitja.udovc@mf.uni-lj.si> To: <informix-list@iiug.org> Sent: Wednesday, December 03, 2003 12:42 PM Subject: time functions > Hello! > > In char field I have some data, which I would like convert to time, subtract > 10 minutes and write it back. For example: > > 905 means 9:05, --> 855 > 1415 means 14:15 --> 1405 > > How to do that? > > Mitja > > What language ? How to handle 0009 ? int hrs int min hrs = dumtime /100 min = dumtime - hrs for cnt = 1 to 10 min = min - 1 if (min < 0 ) hsr = hrs - 1 min = 59 fi rof sending to informix-list