Thanks to You and Martijn

Ciao

Arnaldo

----- Original Message -----
From: "Niki Ivanchev" <niki_iv@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, April 30, 2004 4:51 PM
Subject: Re: [firebird-support] translate from sessagesimal minutes in
centesimal


> Take the minutes part
> lets say z is your field:
> min = z*100 - int(z) * 100
> realMin = min*1.66666666666666
> realTime = int(z)+realMin
>
> You will loose som accuracy but it is unavoidable
>
> that's all
> Regards
> Niki
>
> Arn wrote:
>
> >Hi All.
> >
> >I have a field declared as numeric( 9,2 ).
> >In it I store hours and minutes:
> >eg: 220,30 hours.
> >
> >All fine.
> >
> >Now I must multiplicate that field for money field.
> >eg ( 220,30 hours * 8,45 euro ).
> >
> >How to translate 220,30 in 220,50?
> >to perform the multiplication?
> >
> >TIA
> >
> >Arnaldo
> >
> >
> >
> >
> >
> >Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>