"date" datatype comparison in SQL*Plus
From: Sebastian K F Hung <skfhung_at_undergrad.math.uwaterloo.ca>
Date: Thu, 30 Sep 1993 04:20:31 GMT
Message-ID: <CE5G28.EA2_at_undergrad.math.uwaterloo.ca>
Date: Thu, 30 Sep 1993 04:20:31 GMT
Message-ID: <CE5G28.EA2_at_undergrad.math.uwaterloo.ca>
If I want to make a date comparison in SQL*Plus, should I do the following ?
select start_date_time
from showing
where start_date_time >= to_date('09:00AM','HH:MIAM') and
start_date_time < to_date('09:30AM','HH:MIAM');
if I want to select all the start_date_time ("date" datatype) from 9:00AM to 9:30AM.
thx ..
--Received on Thu Sep 30 1993 - 05:20:31 CET
**************************
Have a nice day !
**************************