[Info-ingres] Selecting rows based on time range

[abc at google.com]

Hi,

I want to find all rows in my database that were updated between 10:00 
and 11:00   (regardless of day).  I have a column called update_date 
that holds the date and time of the row's last update.

I'm trying something like this:

select * from table
where
update_date-date_trunc('day',update_date)  between  '10:00:00' and 
'11:00:00'

But can't quite get it to work.   Any suggestions?

Thanks.