Subject Re: [firebird-support] dates difference function
Author Friedrich Remmert

have a look at the definitions of the date datatype. Within firebird the
calculation is
days = datevalue1 - datevalue2
Datevalues can be seen as Floats where
cast (datevalue as integer)
gives the days since a "startdate". The fraction part gives the part of a day:
fraction of datevalue * 24 = hour with decimal part of an hour.

Am Dienstag, 3. April 2007 12:33 schrieb Alejandro Garcia:
> Hi! I'm trying to calculate a dates difference in a stored procedure in
> InterBase 7.5: given two dates in dd/mm/yyyy format I need its difference
> in days, like this one in SQL 2000:
> set @Days = (SELECT DATEDIFF(DAY,@val1, @val2))
> is there a predefined function to do that? couldn't find it in the
> Language Reference nor Data Reference..
> ---------------------------------
> LLama Gratis a cualquier PC del Mundo.
> Llamadas a fijos y móviles desde 1 céntimo por minuto.
> [Non-text portions of this message have been removed]