[SOLVED] Reading Time

[phpretard]

I know this is probable an easy question but,

 

What is the best way to display "2009-05-27 20:35:18" as this "05-27-2009"?

[gizmola]

explode on the ' ' character.  You'll get two strings -- the first one is the one you want.

[phpretard]

Exploding is something I am still working on (literally and metaphorically). 

 

Any pointers?

[phpretard]

I have it as "2009-05-27" no minutes or seconds

 

I just need to rearrange a little

[PFMaBiSmAd]

If the original value is in a database, you can use the mysql DATE_FORMAT() function in your SELECT query to give you the date in any format you want.

[phpdragon]

$startdate="2009-05-27 20:35:18";

$predate=explode(' ', $startdate);

$splitdate=explode('-', $predate[0]);

$newdate="$splitdate[2]-$splitdate[1]-$splitdate[0]";

echo $newdate;

[Ken2k7]

<?php
$time = '2009-05-27 20:35:18';
$pieces = explode(' ', $time);
echo $pieces[0];

 

Or in SQL

SELECT DATE_FORMAT(`date_column`, '%Y-%m-%d') AS `date`

[phpdragon]

sorry with my result switch

$splitdate[2] and $splitdate[1] around to have the way you first described