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;

Like this post? Share on: TwitterFacebookEmail

Related Articles


Firebird Community



Gems from Firebird Support list