Re: problem with date-funktion

"Patrick Schäfer" wrote:

> Hallo,
> i have a problem:
>
> i have a database table, that includes all dates, when a hotelroom is taken.
> example.
>
> for room number 1 (is taken)
>
> 1 2003-03-02 - 2003-03-20
> 1 2003-03-25 - 2003-03-28
> 1 2003-04-10 - 2003-04-15
> .
> .
> .
> who can i create a table that describe when room number 1 is not taken?
> like for example
>
> 1 - 2003-03-02
> 1 2003-03-20 - 2003-03-25
> 1 2003-03-28 - 2003-04-10
> 1 2003-04-15 -
>
> thank you for your help

Do you mean:

SELECT ...
FROM ...
WHERE some_field IS NULL; ?

Daniel Morgan Received on Tue Feb 11 2003 - 21:13:20 CET