php代码从sql db转换日期格式[关闭]

Question

I'm using DB(sql) to store date. while displaying in php page date format is showing incorrectly and I want to change it to DD-MM-YYYY fromat Currently it is showing as "02/07-14"

DB:

last_download_date (Name) -> datetime (Type)

Code in website

<tr>
    <td>Last Downloaded Date</td>
    <td>{if $last_download_date eq ""}Not downloaded yet.{else}{$last_download_date}{/if}</td>
</tr>

Answer 1

You can take a look at the documentation for PHP date function:

http://php.net/manual/en/function.date.php

You could use

$formated_date = date("d-m-Y", strtotime($dbdatestring));