[Resolved] format a varible

[ATLien]

hello, I am trying to format a date that comes from SQL un formated.

The data I pull from SQL is formated 20050115 I want to convert it to 2005/01/15 before I echo it. How would I go about doing this?

[planetsim]

SELECT DATE_FORMAT( '20050115', '%Y/%m/%d' ) 

Just do it in the MySQL Query.

[ATLien]

I am not sure how todo that. I have a pretty advanced SQL Query so I would prefer to do it with PHP.

[kburger]

Let's see your query. It would probably be a trivial conversion. It's almost always more efficient to let MySQL do whatever work it can on the data before it gets to PHP.

But if you MUST do it with PHP, check out strtotime() or substr().

[Van_T]

echo date('Y/m/d',strtotime('20050115'));

[TheDefender]

Or, if you are dealing with dates that are before Jan 1, 1970, strtotime won't work, so you'd need to use [man]substr[/man] function to extract each of the 3 components, and then just concatenate them using the slash.

$year = substr($date, 0, 4);
$month = substr($date, 4, 2);
$day = substr($date, 6, 2);

echo $year."/".$month."/".$day;