Change the date format

[RON_ron]

I need to change the date format to DD-MM-YYYY. Please help.

 

$SomeVar = $_POST['finco'];
$query = "SELECT * FROM  news_home WHERE code = '".$SomeVar."' ORDER BY timestamp DESC";
$results = mysql_query($query);

$returnS="";
while($line = mysql_fetch_array($results))
{
$returnS.= $line["subject"].",,".$line["timestamp"].",,".$line["News"].",,".$line["links"].",,,";
}
echo $returnS;
mysql_close($link);
?>

[freelance84]

http://php.net/manual/en/function.date.php

[RON_ron]

I believe this is the way to achieve it but it doesn't seem to work! Any idea why is that?

 

$SomeVar = $_POST['finco'];

$query = "SELECT DATE_FORMAT(timestamp, '%d/%m/%Y') FROM  news_home WHERE code = '".$SomeVar."' ORDER BY timestamp DESC";

$results = mysql_query($query);

 

$returnS="";

while($line = mysql_fetch_array($results))

{

$returnS.= $line["subject"].",,".$line["timestamp"].",,".$line["News"].",,".$line["links"].",,,";

}

echo $returnS;

mysql_close($link);

?>

[Jurge]

$date = date('D d Y h:i');

[RON_ron]

Worked! Thanks mate!!