Subject | TIME PROBLEM |
---|---|
Author | apatri2000 |
Post date | 2002-03-26T04:36:36Z |
Hi all.
I have a problem:
Got a field TEMPO_UNITARIO ( UNITARY_TIME ) declared as numeric(
9,4 ) in which i put the TIME necessary to build an object, e.g. 0,20
stay for 20 minutes, 1,45 stay for 1 hour and 45 minutes.
Another field PEZZI ( PIECES ) declared as NUMERIC( 9,4 ) hold the
number of objects to build eg 3 stay for 3 objects to build.
Problem: how to calculate the total amount of time necessary to build
all the objects---->
TOTAL_TIME = UNITARY_TIME * PIECES obvously not work.
Please boy, any hint???
Thanks
Tony
I have a problem:
Got a field TEMPO_UNITARIO ( UNITARY_TIME ) declared as numeric(
9,4 ) in which i put the TIME necessary to build an object, e.g. 0,20
stay for 20 minutes, 1,45 stay for 1 hour and 45 minutes.
Another field PEZZI ( PIECES ) declared as NUMERIC( 9,4 ) hold the
number of objects to build eg 3 stay for 3 objects to build.
Problem: how to calculate the total amount of time necessary to build
all the objects---->
TOTAL_TIME = UNITARY_TIME * PIECES obvously not work.
Please boy, any hint???
Thanks
Tony