Subject arithmetic operations on time fields
Author Arnaldo
Post date 2001-02-04T14:14:53Z
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