Integer checks

Posted in 2008

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

monkeys paw — Tue, 16 Sep 2008 14:05:35 -0400 — source: Usenet: comp.databases.informix

Hi all, I need an integer to conform to military time, so i have to check that the tens digit is no more than 59, i.e. 2159 is a valid time, 2162 is not. I've not seen much "arithmetic" done in 4gl so could someone suggest the best way to check an int for this condition.

↪ replying to monkeys paw

Obnoxio The Clown — Tue, 16 Sep 2008 19:32:11 +0100 — source: Usenet: comp.databases.informix

monkeys paw wrote: > Hi all, I need an integer to conform to military time, so > i have to check that the tens digit is no more than 59, > i.e. 2159 is a valid time, 2162 is not. > > I've not seen much "arithmetic" done in 4gl so could someone > suggest the best way to check an int for this condition. > What's wrong with a DATETIME HOUR TO SECOND ? -- Cheers, Obnoxio the Clown http://obotheclown.blogspot.com

Glossary

4GL (Informix-4GL)