> Hi all,
>
> In a stored procedure I need to be able to compare 2 time
> stamp values ( ie TS1 and TS2)
>
> I need to be able to test if (TS1 - 3 minutes) is less than TS2
>

I think this is right...

if(:ts1 - (3*60) < :ts2)then
begin
-- Do something here
end


Nige.