postgresql query with time difference

Question

I have table structure as follows

id name point last_updated refresh_frequency
1 'abc' 100 2015-08-28 01:00:00 24

last_updated is datetime field and refresh_frequency is int

I want to get all rows which having last_updated value before refresh_frequency (in Hours) from current time, How to write a query for this?

Patrick · Accepted Answer · 2015-08-03 09:18:18Z

2

SELECT *
FROM tablename
WHERE last_updated < NOW() - refresh_frequency * INTERVAL '1 hour';

Patrick

33k7 gold badges73 silver badges102 bronze badges

answered Aug 3, 2015 at 5:25

trex005

5,1354 gold badges32 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1