Subject arithmetic operations on time fields
Author Arnaldo
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 * 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?