How to get only full hour data

Question

Hy in my DB i have data that occurs every 10 min (timestamp) and i would like to get only those that have timestamp that is equal to full hours between one timeframe

for example only those that have timestamp time equal 09.00, 10.00, 11.00, 12.00, 13.00

`WHERE timestamp = ? OR timestamp = ? ...` – Justinas Dec 21 '22 at 15:35 — Justinas, Dec 21 '22 at 15:35

score 3 · Accepted Answer · answered Dec 21 '22 at 15:45

3

Extract the minute portion of the timestamp with DATE_PART_STR(mydate, 'minute') then compare it to zero.

answered Dec 21 '22 at 15:45

Chris Maurer

2,339
1
9
8

CRATE INDEX ix1 ON mybucket(DATE_PART_STR(mydate, 'minute')); SELECT d.* FROM mybucket AS d WHERE DATE_PART_STR(mydate, 'minute') = 0; – vsr Dec 21 '22 at 17:53

How to get only full hour data

1 Answers1