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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
