How to get # of minutes difference between two Timestamp fields in Interbase 7.5?
Posted on 2009-03-30
I'm working w/ Interbase 7.5 for the first time, and all I can say is I didn't realize what I was missing out on before. I have a TIMESTAMP field, and the CURRENT_TIMESTAMP, and I'd like to know how many minutes has elapsed between the two. DateDiff appears to only work on two dates. I do know the difference between two timestamps is a numeric(x,y) #, w/ the integer part being the # of days and the decimals being fractions of the day.
The query tries to get the records created w/ in the last X number of minutes.
What would my WHERE clause look like for such a query?
WHERE (magical_timestamp_comparison_resuling_in_minutes_diff) > = 15
Thank you all in advance!