Select rows based on date in Oracle database

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

Leave a Reply