On 28/09/2010 12:45 p.m., Helen Borrie wrote:
> 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)
>
> ./heLen
>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>