表日期时间与sql查询中的日期比较？

in my table column datecreated the value is 2012-12-04 00:29:30 I would like to compare it to the date now with the format of d/m/Y something like this:

$date = date('d/m/y');
$sql = mysql_query("Select * from `tblname` where `datecreated` > '".$date."' ");

but I think not working any help that could make it? thanks ..

you can use DATE_FORMAT function to format your column

"Select *, DATE_FORMAT(`datecreated`, '%e/%c/%Y') AS `datecreated` from `tblname` where `datecreated` > '$date'"