:)))

Hi Arnaldo,

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

good luck.

----- 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