change date format with data back from mysql

[jonsamwell]

Hi,

 

mysql stores date as Y-m-d H:i:s.

 

How would i change the format of the string i get back after a sql query so that the format is "d-m-Y H:i:s".

 

I have tried:

 

$date = date($row['previous_login']);

$date = date_format($date, "d-m-Y G:i:s");

 

but i get back an error.

 

Any ideas?

 

Thanks

 

Jon

[vbnullchar]

$date_s = strtotime($row['previous_login']);

$date = date_format($date_s, "d-m-Y G:i:s");

[jonsamwell]

$date_s = strtotime($row['previous_login']);

$date = date_format($date_s, "d-m-Y G:i:s");

 

thanks for replying

 

it throws back the error

 

"Warning: date_format() expects parameter 1 to be DateTime, integer given in C:\wamp\www\SRC\PHP\db.php on line 301"

 

any ideas

[vbnullchar]

sorry here it is, use date only.

 

$date_s = strtotime($row['previous_login']);
$date = date($date_s, "d-m-Y G:i:s");

[jonsamwell]

sorry here it is, use date only.

 

$date_s = strtotime($row['previous_login']);
$date = date($date_s, "d-m-Y G:i:s");

 

Cool thanks alot it worked when i changed the order of parameters around with the dat() funt

[jonsamwell]

Great thanks!

 

This is the final code that worked

 

$date_s = strtotime($row['previous_login']);

$date = date("d-m-Y G:i:s", $date_s);