|Subject||Re: [ib-support] adding time|
>>>>> On Sun, 01 Dec 2002 21:34:37 -0000, "duilio_fos" <irel_llc@...> said:df> This makes me want to provide my customer with a QBE product.
df> Is there a QBE product (free or commercial) that could do the
df> conversion from the float result of the sum into the hhh:mm
df> human readable format ?
df> Or do you have better ideas re the _column_ format ?
Duilio, I did not understand the relation between the QBE and what you
are asking: to convert the time into a human readable string you can
write a simple UDF, or even an SP. AFAICT, QBE would make easier
expressing the "grouping" and "filtering" parts of the query, but
won't make them more readable.
If you need an example, I can share my code with you, I already have
such a UDF, in two version, C and Pascal.
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.