CODEWITHSUNDEEP
phpdateformatting
Simon
Simon

Reputation: 23141

How do I change a date's format in 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

Upvotes: 1

Views: 455

Answers (4)

Vijin Paulraj
Vijin Paulraj

Reputation: 4618

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

Upvotes: 0

amphetamachine
amphetamachine

Reputation: 30595

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

Upvotes: 3

BoltClock
BoltClock

Reputation: 723498

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

Upvotes: 1

Joe Mastey
Joe Mastey

Reputation: 27099

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

Upvotes: 4

Related Questions