Robert Martin wrote:
In a Stored Procedure I want to see if an event is within 5 minutes. How to I add minutes to a TimeStamp? I know I can add / subtract 1 to add / subtract a day I assume I can add a fraction to add minutes?
Helen Borrie answers:
Add days and/or part-days...
Don't be tempted to use (5/1440) - that expression results in zero! For 5 mins this expression should get you near enough:
aTimestamp + (5.00000000/1440)
Reinier Olislangers answers:
Or use the DATEADD function available since FB v2.1:
from the sample provided:
select dateadd (minute, 5, time 'now') from rdb$database;