Hi all...

U can look at this link, maybe help.
http://firebird.sourceforge.net/index.php?op=useful&id=ostenried_1

Regards
Paul M

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ali Gökçen
Sent: Wednesday, April 19, 2006 3:39 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: difference between TIMESTAMPs

Math unforgives about paranthesis sometimes..


secs bigint;
plustime time;

secs = (checkout-checkin)*84000;
--integer delta as seconds.

days = secs/84000; -- number of full days

plustime = cast('00:00' as time) + (secs-(days*84000));
-- remainder time







++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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