1. select * from tableName where fieldName like '2009-12-29%';
2. select * from tableName where ( datediff ( fieldName , '2009-12-29' ) = 0 );
3. select * from orders where tableName between '2009-12-10 24:00:00' and '2009-12-29 23:00:00';
4. select * from tableName where year(fieldName)='2009' And month(fieldName)='12';