Re: Counting Seconds using 4GL

DEFINE difference INTERVAL second(9) to second LET difference = end_time - start_time I suspect the problem you had was in wondering how to define a second as more than 99 - hence the second(9) which gives you 9 digits. cheers j. Richard W Sinyem <senyem@malitnet.net.my> on 08/14/98 01:30:59 AM To: "'informix-list@iiug.org'" <informix-list@iiug.org> cc: (bcc: Jack Parker/Boston50/Epsilon) Subject: Counting Seconds using 4GL Dear All, Greetings. How do I compute the number of seconds based on two datetime as exampled below: start time = 08/08/1998 23:10:05 end time = 08/09/1998 01:34:06 Thanks Regards Richard