Re: Hotel Booking dates subquery
Date: Sun, 10 Nov 2002 13:12:32 +0000
Message-ID: <2kmssu0oq18l60fc1srtbf6rp7e3euobve_at_4ax.com>
Scotty wrote:
[blah...blah...blah]
I think ive got it... Need to run some more tests, but...
SELECT booking_id,room_id,startdate,enddate
FROM booking
WHERE
to_date('29-11-02','dd-mm-yy')-to_date(sysdate,'dd-mm-yy') <
to_date(startdate,'dd-mm-yy')-to_date(sysdate,'dd-mm-yy')
and
to_date('05-12-02','dd-mm-yy')-to_date(sysdate,'dd-mm-yy') <
to_date(startdate,'dd-mm-yy')-to_date(sysdate,'dd-mm-yy')
or
to_date('29-11-02','dd-mm-yy')-to_date(sysdate,'dd-mm-yy') >
to_date(enddate,'dd-mm-yy')-to_date(sysdate,'dd-mm-yy')
and
to_date('05-12-02','dd-mm-yy')-to_date(sysdate,'dd-mm-yy') >
to_date(enddate,'dd-mm-yy')-to_date(sysdate,'dd-mm-yy');
Can someone with a brain left (mines committed suicide) tell me if I'm on the right track? Received on Sun Nov 10 2002 - 14:12:32 CET