Jump to content

ho to use date function with mysql?


vinod_vsd

Recommended Posts

$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

Link to comment
https://forums.phpfreaks.com/topic/260058-ho-to-use-date-function-with-mysql/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.