Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date and time comparision, calculauion
On Wed, 26 Feb 1997 18:18:57 GMT, John_Steven.Remus_at_akh-wien.ac.at (John Remus) wrote:
>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
Sorry!
I've forgotten to say that this SQL Stat. doesnt work and the Subject should mean: date and time comparision, calculation Received on Wed Feb 26 1997 - 00:00:00 CST