Did you try: select ... where to_char(date_col,'HH24:MI') between '06:00' and '18:00';
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Forum Rules