Subject Re: [ib-support] COMPUTED FIELD BY SUBTRACTING TWO TIME FIELDS
Author Ali Gokcen
Post date 2001-01-28T21:51:38Z
Thank you Arnaldo.
 
please look at,
    www.ibphoenix.com   Ann's docs  (  home page of  uncle Jim's IB  ;)    &  Thanks to him for this great product!  )
    www.mers.com
 
----- Original Message -----
From: Arnaldo
Sent: Sunday, January 28, 2001 10:57 PM
Subject: R: [ib-support] COMPUTED FIELD BY SUBTRACTING TWO TIME FIELDS

 
----- Original Message -----
From: Ali Gokcen
Sent: Sunday, January 28, 2001 8:23 PM
Subject: Re: [ib-support] COMPUTED FIELD BY SUBTRACTING TWO TIME FIELDS
 
ALI. YOU ARE GREAT.
 
THANKS FOR THE EXAMPLE AND FOR THE KINDLY REPLY.
THIS EXAMPLE WORKS PERFECTLY.
AGAIN THANKS
ARNALDO.
 
P.S. Please. Where I find some info about Interbase tips and tricks?????
 
CIAO. 
Arnoldo,
sorry me about my shortcut  expression,
i like to show how catch it instead of  to give ready fish.   ;)
 
CREATE TABLE TIMEDELTA     
         (
            T1                TIME,  // start time
            T2                TIME,  // stop time
            DELTA_HM  COMPUTED BY ( CAST('00:00:00' as time) + (t2-t1))     // delta as HH:MM:SS
          );
you can use like my ex. above.  SP will inc. your apps complexty.
 
good luck.