Re: Using INTERVAL datatype to calculate payrate

Posted in 1997

dalla@informix.com — 24 Sep 1997 20:55:47 GMT — source: Informix-list mailing list archive (1991-1998)

: I am attempting to use 4GL 4.1 to accumulate the values of a : DATETIME HOUR TO MINUTE variable and then multiply that value by : a rate of pay (i.e. $10.50) to obtain a weekly salary. : Currently, I see no way to mutliply the payrate by the interval in : time to obtain the salary. You can't multiply directly aninterval hout to minute. However, you can promote it to interval minute(5) to minute and then compute the earnings. I think this is doable. dalla