MySQL Forums
Forum List  »  French

Re: Requete sur des périodes
Posted by: Selim Lasram
Date: June 02, 2009 08:53AM

En supposant que les dates choisies par l'utilisateur sont 2009-05-29 et 2009-06-01,
qu'est ce que ça donne avec :
SELECT date_debut, date_fin, disponible
FROM matable
WHERE (date_debut BETWEEN '2009-05-29' AND '2009-06-01') AND (date_fin BETWEEN '2009-05-29' AND '2009-06-01')

Options: ReplyQuote


Subject
Views
Written By
Posted
6515
May 30, 2009 11:26AM
3325
May 30, 2009 05:23PM
3603
May 31, 2009 02:24PM
3422
June 01, 2009 04:18AM
Re: Requete sur des périodes
3399
June 02, 2009 08:53AM
3445
June 15, 2009 01:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.