Subject | RE: [firebird-support] Re: difference between TIMESTAMPs |
---|---|
Author | Alan McDonald |
Post date | 2006-04-19T10:13:36Z |
> ok, so i have something like 8.306454...if i multiple this by 24 i0.354896*60
> 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..
correct
>truncate the decimal and you have the integer, subtract them and you have
> Are there functions in FireBird to get integer and fraction parts of a
> number...
the deciaml fraction
>UDFs have been a part of my workspace for many years - I don't want to ever
> 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:
lose them :-)
Alan