如何在PHP中更改日期格式？

I get data from a database in YYYY-mm-dd format, but I want to show just dd.mm (example - I get 2010-05-28; I want to show 28.05)

Could you help me?

Thanks

You can use the date_format function to format the data as it comes out of the database. For example:

mysql> select tf, date_format(tf, '%d.%m') from times;
+---------------------+--------------------------+
| tf                  | date_format(tf, '%d.%m') |
+---------------------+--------------------------+
| 2010-11-02 00:00:00 | 02.11                    |
+---------------------+--------------------------+

The fast way is to convert to timestamp and back out to a date. This isn't safe for dates outside the normal epoch though:

$dateString = date('d.m', strtotime($dateFromDb));

To interchange date formats I use strtotime() in conjunction with date(), like this:

// Assuming the date that you receive from your database as
// YYYY-mm-dd is stored in $row['date']
$newformat = date('d.m', strtotime($row['date']);

To convert the date format from yyyy-mm-dd to dd.mm in php,

<?php

$dt='2010-05-28';
$dt=date('d.m',strtotime($dt));
echo $dt;

?>

The o/p will be, 28.05