Subject Re: [ib-support] arithmetic operations on time fields
Author Ali Gokcen

Hi Arnaldo,

(Hours - '00:00:00') * 1.666 = ( diff. as seconds) * 1.666

good luck.

----- Original Message -----
From: Arnaldo
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?


I have a field HOURS declared as TIME.

Now i must do some operations in, a procedure, on it, let say: -->> HOURS *
I have did: cast( HOURS as numeric( 18,2 ) ) * 1.666 or
cast( HOURS as float ) * 1.666.
Neither works.

Please, somebody help?


Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to: