PHP MySQL Requête sur champ DATETIME

Réponse acceptée !
Bonjour,

<?php
//-- toutes les dates comprises entre les 2 dates ---------------------------------
$sql = 'SELECT o.id, o.id_customer, DATE_FORMAT(o.date, \'%Y-%m-%d\') as laDate,
               c.compagny, c.name, c.firstname
        FROM cust_offer as o, contact as c
        WHERE o.id_customer = c.id
        AND o.date BETWEEN \'2008-10-15\' AND \'2008-12-10\'
        AND o.is_proforma = \'0\'
        ORDER BY o.id DESC';

//-- toutes les dates non comprises entre les 2 dates -----------------------------
$sql = 'SELECT o.id, o.id_customer, DATE_FORMAT(o.date, \'%Y-%m-%d\') as laDate,
               c.compagny, c.name, c.firstname
        FROM cust_offer as o, contact as c
        WHERE o.id_customer = c.id
        AND o.date NOT BETWEEN \'2008-10-15\' AND \'2008-12-10\'
        AND o.is_proforma = \'0\'
        ORDER BY o.id DESC';
?>