----- Original Message -----
From: Ali Gokcen <alig@...>
To: <ib-support@yahoogroups.com>
Sent: Sunday, February 04, 2001 4:04 PM
Subject: Re: [ib-support] arithmetic operations on time fields


> :)))
>
> Hi Arnaldo,
>
> (Hours - '00:00:00') * 1.666 = ( diff. as seconds) * 1.666
>
> good luck.

THANKS, Ali.
As usual You are going to be indispensable to me.

Again Thanks.
Arnaldo


>
> ----- Original Message -----
> From: Arnaldo
> To: ib-support@yahoogroups.com
> Sent: Sunday, February 04, 2001 4:14 PM
> Subject: [ib-support] arithmetic operations on time fields
>
>
> Hi all.
>
> I got a problem:
>
> There is a way to multiplicate a time field for a numeric variable?
>
> eg:
>
> I have a field HOURS declared as TIME.
>
> Now i must do some operations in, a procedure, on it, let say: -->> HOURS
*
> 1.666.
> I have did: cast( HOURS as numeric( 18,2 ) ) * 1.666 or
> cast( HOURS as float ) * 1.666.
> Neither works.
>
> Please, somebody help?
>
> TIA
> Arnaldo
>
> Yahoo! Groups Sponsor
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>