ma11hew28
ma11hew28

Reputation: 126327

PostgreSQL: SELECT WHERE less than 15 minutes old

From the events table below, how do I select events created less than 15 minutes ago?

CREATE TABLE events (
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
);

Upvotes: 43

Views: 37236

Answers (2)

Frank Heikens
Frank Heikens

Reputation: 127086

SELECT created_at FROM events WHERE created_at > NOW() - INTERVAL '15 minutes';

Upvotes: 91

ma11hew28
ma11hew28

Reputation: 126327

SELECT * FROM events WHERE age(now(), created_at) < '15 minutes';

Upvotes: 15

Related Questions