my query it's right ?

[manjava]

hi,

i have this scénario :
If request bookings with the following parameters: from = 2009-06-19T08:00:00, to = 2009-06-19T09:00:00

The distribution system application must return booking B1 with a status = Create
If request bookings with the following parameters: from = 2009-06-19T09 :30 :00, to = 2009-06-19T09 :40 :00

The distribution system application must return no booking
If request bookings with the following parameters: from = 2009-06-19T09 :50 :00, to = 2009-06-19T10 :10 :00
If request bookings with the following parameters: from = 2009-06-19T10 :20 :00, to = 2009-06-19T11 :00 :00

The distribution system application must return booking B2 with a status = Cancel

and i want to translation in code Mysql i do that

select REPLACE(arrival, ' ', 'T') as arrival, REPLACE(departure, ' ', 'T') as departure , case
                        when departure = '2009-06-19 09:00:00' and arrival= '2009-06-19 08:00:00' then 'create'
                        when departure > '2009-06-19 09:00:00' and arrival> '2009-06-19 08:00:00' then 'no booking'
                            when departure > '2009-06-19 09:00:00' and arrival> '2009-06-19 08:00:00' then 'cancel' end as action
 
                        from jo_jomres_contracts

:
it's true or false because i want the time inclusion .

Thanks in advance