Re: Hotel Booking dates subquery
Date: 11 Nov 2002 18:37:49 +0100
>>Jan Hidders wrote:
>>>Btw., you can still
>>>simplify your query a litte: you can remove tha -todate(...) everywhere and
>>>the first and second equations are redundant.
>>Ok, I'll have a play with it and see what optimisation can be
>>performed. I've yet to put in the check for room status so it should
>>hopefully be a decent query when its done.
>Here's the end product, hopefully if anyone can see any potential
>problems with this query they'll comment.
>TO_DATE('17-11-02','dd-mm-yy') - sysdate < startdate - sysdate
>TO_DATE('20-11-02','dd-mm-yy') - sysdate > enddate - sysdate;
- Jan Hidders