Is there a better way to write the statement below with postgre. It works fine, wondering if there might be a way with with only 1 extract. I just need only results returned if they fall on a 10 minute interval. Thanks.
SELECT * FROM t1
WHERE EXTRACT(minute FROM timestamp) = 0 OR
EXTRACT(minute FROM timestamp) = 10 OR
EXTRACT(minute FROM timestamp) = 20 OR
EXTRACT(minute FROM timestamp) = 30 OR
EXTRACT(minute FROM timestamp) = 40 OR
EXTRACT(minute FROM timestamp) = 50;
SELECT * FROM t1
WHERE EXTRACT(minute FROM timestamp) = 0 OR
EXTRACT(minute FROM timestamp) = 10 OR
EXTRACT(minute FROM timestamp) = 20 OR
EXTRACT(minute FROM timestamp) = 30 OR
EXTRACT(minute FROM timestamp) = 40 OR
EXTRACT(minute FROM timestamp) = 50;
Comment