date and time comparision, calculauion

Hi everybody!

I have a little problem with the date datatype handling.

I like to select a date(time) type column and restrict it for example between 20:00 and 7:00.
I tried like this:

select to_char(time,'HH:MI')
from time_table
where to_date(to_char(time,'HH:MI')) > to_date('20:00','HH:MI') and to_date(to_char(time,'HH:MI')) < to_date('07:00','HH:MI') ;

In the same way I would like to know how I can calculate times and dates with each other.

Thank's in advance

John Remus
John_Steven.Remus_at_akh-wien.ac.at
General Hospital Vienna
Austria
John Remus
John_Steven.Remus_at_akh-wien.ac.at
General Hospital Vienna
Austria Received on Wed Feb 26 1997 - 00:00:00 CST