ho to use date function with mysql?

[vinod_vsd]

$sql ="SELECT recieve_date FROM transit ";

$result1 =mysql_query($sql);

 

while($row1 = mysql_fetch_array($result1))

{

echo "<td>". $row1['recieve_date'] ."</td>";

}

 

//i get output in this format

 

            recieve_date

2025-03-20

2016-03-20

2016-03-20

2017-03-20

2017-03-20

2017-03-20

2017-03-20

 

 

i want to show like 25-03-2012 with date

[fenway]

Don't mark topics solved without posting the solution.