Jump to content

Change the date format


RON_ron

Recommended Posts

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);
?>

Link to comment
Share on other sites

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);

?>

Link to comment
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.