yadajopp wrote:

> In a php script of mine, I have the following mysql query.
>
> UPDATE users SET logged_in=0, timestamp=timestamp where logged_in=1
> and username='$Loginname' AND (now()+0)-(date_add(timestamp,interval
> 600 second))>=0");
>
> now my question is, is there a simular function to date_add in
> firebird? or is there another way to get the same result?

TIMESTAMP >= CURRENT_TIMESTAMP - 10 / ( 24 * 60 )

Should work, time is just fraction of one day and so can be added
directly :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services