I thought you were trying to avoid UDFs...
F_TRUNCATE from FreeUDFLib.dll
select f_truncate(8.657) from rdb$database
returns 8
Alan

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]On Behalf Of d_dude_2003
> Sent: Wednesday, 19 April 2006 9:47 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: difference between TIMESTAMPs
>
>
> cast(8.657 as integer) returns 9. WTF!
>
> --- In firebird-support@yahoogroups.com, Ali Gökçen <ali_gokcen@...>
> wrote:
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>