|Subject||arithmetic operations on time fields|
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.
Please, somebody help?