Further
select (cast('Apr 19, 2006 12:00' as timestamp)-cast('Apr 13, 2006 13:00' as
timestamp)) from rdb$database
returns 5.98333333
select f_truncate(cast('Apr 19, 2006 12:00' as timestamp)-cast('Apr 13, 2006
13:00' as timestamp)) from rdb$database
returns 5


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
>
>
>
>
>
>
>
>