Select rows based on date in Oracle database

Leave a Comment / Systems / By

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 Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.