Subject Re: [ib-support] Date/Time Function
Author Helen Borrie
At 05:11 AM 12-09-02 +0000, you wrote:
>In Firedbird are there any date/time function as same as in ORACLE or
>MSSQL? Do it allow to add or substract between 2 dates? In MSSQL I
>used DATEDIFF function to find out a differences between 2 dates. Any
>functions in Firebird do like this??? If not, it means that I have to create
>UDF myself, right?

Yes, just subtract the older date from the more recent one to get the
interval in days.

>Sorry for asking many questions. I'm a newbie in Firebird but I have to
>finish my project soon.

You would save time by downloading the manuals...see the Downloads >
InterBase page at