[Info-ingres] Selecting rows based on time range

[abc at google.com]

On 10/03/2016 11:42, Allan Biggs wrote:
>    1> select on_date  from my_table
>       where date_part('hours',on_date) = '11'
>       or   date_part('hours',on_date) = '10'
>

Thank you.   I ended up finding the interval function and this seems to 
work well too.
select * from <table>
where  interval('hours',update_date-date_trunc('day',update_date)) 
between  10 and 11