Jump to content

Change the date format


RON_ron
 Share

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

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • 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.