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

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