Postgres Pro
Downloads
Home   >   mailing lists

timestamp differences - Mailing list pgsql-general

From Garry Saddington
Subject timestamp differences
Date
Msg-id 200812282140.28858.garry@schoolteachers.co.uk
Whole thread Raw
Responses Re: timestamp differences
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Finding foreign keys that are missing indexes
Next
From: Adrian Klaver
Date:
Subject: Re: timestamp differences