How to make 20031225020519 into 25 DEC 2003???

cindango

I tried this:

$article_date = $row['date']; 
$datetoprint = date("m M Y",$article_date); 

echo "<font color=#33ccff><b>".$datetoprint."</b></font>"; 
echo "<font color=#33ccff><b> // ".$row['title']."</b></font>";
echo "<br>";
echo "".$row['newsdata']."";
echo "<p>";

But I get this: 01 Jan 2038

Shrike

$datetoprint = date("m M Y",strtotime($article_date));

Weedpacket

Originally posted by Shrike
$datetoprint = date("m M Y",strtotime($article_date));
[/B]

I doubt that would work - MySQL timestamps aren't widely recognised outside MySQL.

The easiest would be to use MySQL's date and time functions and format it there.

LordShryku

Been answered a couple times before too. Searching the forums would have helped you.
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10263256&highlight=timestamp

diego25

That's not a UNIX or MySQL timestamp though. That's just the numbers of a date concatenated together.

Try this:

<?
$months = array("JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP", "OCT", "NOV", "DEC");
$article_date = '20031225020519';
preg_match('/(\d{4})(\d{2})(\d{2}).*/', $article_date, $matches);
printf('%d %s %d', $matches[3], $months[$matches[2]-1], $matches[1]);
?>

Diego

Weedpacket

Originally posted by diego25
That's not a UNIX or MySQL timestamp though. That's just the numbers of a date concatenated together.

Isn't that how a MySQL timestamp is formatted (at least, a TIMESTAMP(14))?

Shrike

Oops. Too much Xmas beer. I mean cheer.