How do I change a date's format in PHP?

Question

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

Answer 1

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));

Answer 2

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']);

Answer 3

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                    |
+---------------------+--------------------------+

Answer 4

use the mysql date_format function. this site will show you how to use it http://www.mysqlformatdate.com