--- In firebird-support@yahoogroups.com, Grant Brown <grant@s...>
wrote:
Hi Grant,

1440 mins per day (24x60)

+1 gives + 1 day.
+3/1440 gives + 3 minutes etc

if ((TS1 - 3/1440) < TS2) then
begin
-- less than
end
else
begin
-- not less than
end

Adam

> 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
>
> Could someone show me how to do this.
>
> --
> Regards,
> Grant Brown
>
> Product Development Manager
> Phone : 02 4229 1185
> Mobile : 0412 926 995
> Email : grant@s...
> Web : www.sitedoc.com.au
>
> SiteDoc - Easy to Use - Powerful Results