Select Date Now from MySQL

$perintah="select DATE_FORMAT(now(),'%Y-%m-%d') as tgl_periode";
$hasil=mysql_query($perintah) or die($perintah);
while ($row=mysql_fetch_array($hasil))
{
$tgl_periode=$row["tgl_periode"];
}