On Sunday 28 December 2008 1:40:28 pm Garry Saddington wrote:
> I have a timestamp column that I want to compare with current timestamp.
> I want to get all rows that are less than 10 minutes old. I have searched
> but can not find how to do this, any pointers?
> regards
> Garry
select * from foo where ts_fld > now() - 'interval 10 min'
--
Adrian Klaver
aklaver@comcast.net