Subject Re: [firebird-support] Adding minutes to a TimeStamp
Author Helen Borrie
At 11:39 AM 28/09/2010, Robert martin wrote:
> Hi
>In a Stored Procedure I want to see if an event is within 5 minutes.
>How to I add minutes to a TimeStamp?

Add days and/or part-days...

>I know I can add / subtract 1 to
>add / subtract a day I assume I can add a fraction to add minutes?

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)