Subject RE: [firebird-support] Re: difference between TIMESTAMPs
Author Alan McDonald
> ok, so i have something like 8.306454...if i multiple this by 24 i
> should get duration in hours and fraction of hour...is it correct...?
>
> so its 199.354896 which is 199 hours and about 0.654896*60 = 21
> minutes..

0.354896*60
correct

>
> Are there functions in FireBird to get integer and fraction parts of a
> number...

truncate the decimal and you have the integer, subtract them and you have
the deciaml fraction

>
> Will there be a day when the developer can use a complete set of
> language functions to operate with data without going for UDFs and
> having other headaches...
>
> --- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...>
> wrote:

UDFs have been a part of my workspace for many years - I don't want to ever
lose them :-)

Alan