format mysql datetime with php

[Hailwood]

hi there,

 

 

how should i go about formatting a mysql datetime with php?

 

 

i have tried Date('jS M Y', $qry['msg_add_date']) but i simply get 1st Jan 1970

[trq]

Your much better off doing this within your query...

 

DATE_FORMAT.

[Hailwood]

thorpe do you ever sleep?

 

haha but yeah, i thought about doing that,

 

except this table has over 300 columns (not designed nor can be changed by me) and so the query is is select * ...

 

 

while($row = mysql_fetch-assoc...)

{

foreach($row as $k => $v )

  $$k = $v;

 

 

so i cant really do it in the query

 

 

cheers.

 

 

came across using strtotime on it before using date

[trq]

What format do the dates appear to be in? Example?

[Hailwood]

just normal date time i.e 2010-07-01 22:42:21

[trq]

date takes a timestamp, not a formatted date. You'll want to run your dates through strtotime to get a timestamp then into date.