SELECT * 
    FROM Customer 
    WHERE month(Customer.BirthDate) = 1; 
<END>    
¸Ã SQLÓï ¾ä ÓÐ ¶à ÖÖ Ð´ ·¨ £º 
    1¡¢ SELECT * FROM Customer WHERE month(Birthday)=1 AND 
    Day(Birthday)>=1 AND Day(Birthday)<=31 
    2¡¢ SELECT * FROM Customer WHERE FORMAT(Birthday,"mmdd") BETWEEN 
    "0101" AND "0131" 
<END>     
SELECT * From List WHERE listDate like '2000-12-*' 
    Ö÷ ³Ö ÈË ×¢ £º ´ó ¸Å Ó¦ ¸Ã Ê¹ ÓÃ SELECT * From List WHERE Format(listDate, 'yyyy-mm-dd') like '2000-12-*' 
<END>     

    
    