PHP Question for Raven

Richman · New Member Joined: Jul 01, 2004 Posts: 10

I wrote a PHP script that accesses a MySQL database to retrieve a number of schedule entries. I was wondering how I could format the date coming from the MySQL database to look more desirable, like a mm/dd/yy fasion.

Raven · Posted: Thu Jul 01, 2004 2:11 pm

It depends on the incoming format, of course. See if these links help you

Only registered users can see links on this board!
Get registered or login to the forums!

Richman · New Member Joined: Jul 01, 2004 Posts: 10

This is the format, I got it using the SQL function NOW().
2004-06-30 14:00:40

Raven · Posted: Thu Jul 01, 2004 2:16 pm

Yep, that would do it Smile

Richman · New Member Joined: Jul 01, 2004 Posts: 10

How would i get that into mm/dd/yy? I looked at the php.net manual and couldn't seem to find a way Embarassed

sixonetonoffun · Posted: Thu Jul 01, 2004 2:52 pm

Here is a crude working example.

Code:

<?
$var="2004-06-30 14:00:40";
list($part1,$part2)=explode(" ", "$var");
list($nwyr,$nwmm,$nwdt)=explode("-", "$part1");
echo ("$nwmm-$nwdt-$nwyr");
?>

But in the long run it might be easier to store it in the format you want to retrieve it in since it would make it a little faster.

Richman · New Member Joined: Jul 01, 2004 Posts: 10

Thats one good point man...

Raven · Posted: Thu Jul 01, 2004 3:39 pm

Code:

<?
$now = '2004-06-30 14:00:40';
echo date('m-d-Y',strtotime($now));
?>

Richman · New Member Joined: Jul 01, 2004 Posts: 10

Thanks a lot! That should do it. RavensScripts