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.
http://es.voice.yahoo.com

[Non-text portions of this message have been removed]