E.g. to select rows with a timestamp on minutes 0, 5, 10, ..., 55
SELECT * FROM t WHERE MOD(to_number(to_char(date_time_col, 'mi')),5)=0 |
E.g. to select rows with a timestamp on minutes 0, 5, 10, ..., 55
SELECT * FROM t WHERE MOD(to_number(to_char(date_time_col, 'mi')),5)=0 |