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
trying stuff with code
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
You must be logged in to post a comment.