SQL Date related

SELECT * FROM `DataSet` WHERE  DATE( CreateDate ) = CURDATE( )

DATE(  CreateDate ) > DATE(  '2012-6-1' )


SELECT *
FROM  `DataSet`
WHERE DATE(  `CreateDate` ) > ( SELECT DATE_SUB( CURDATE( ) , INTERVAL 5 DAY ) )


SELECT * FROM `DataSet` WHERE DATE(`CreateDate`) < (SELECT DATE_SUB(CURDATE(),INTERVAL 120 DAY))


SELECT * FROM `DataSet` WHERE DATE(`CreateDate`) between (SELECT DATE_ADD(CURDATE(),INTERVAL 10 DAY)) and (SELECT DATE_SUB(CURDATE(),INTERVAL 10 DAY))