Convert to dd / mmm / yyyy

Question

I get the date from MySQL in the format yyyy / mm / dd 00:00:00. I want to convert this date to dd / MMM / yyyy format in PHP.

Answer 1

Use PHP date and strtotime :

$formatted = date('d/M/Y', strtotime($date_from_mysql));

Or use MySQL built in DATE_FORMAT :

SELECT DATE_FORMAT(datetime, '%d/%b/%Y') datetime FROM table

Or, you can mix a little of both flavors:

SELECT UNIX_TIMESTAMP(datetime) timestamp FROM table;

$formatted = date('d/M/Y', $timestamp);

The last method is convenient if you need to get several different formats on one page; let's say you want to print the date and time separately, then you can just use the date ('d / M / Y', $ timestamp) and the date ('H: i', $ timestamp) without any further conversion.

Answer 2

, php, MySQL date_format().

SELECT date_format(dt, '%d/%m/%Y') ...

Answer 3

date() PHP (docs).

print date('d/M/Y', $row['tstamp']);

This applies if your date field is DATETIMEor TIMESTAMP. Repeat to wrap the field in UNIX_TIMESTAMP()( docs ), for example. SELECT ..., UNIX_TIMESTAMP(dateField) AS tstamp FROM ....

Answer 4

In fact, you can force mySQL to convert the date to a unix timestamp

SELECT UNIX_TIMESTAMP(field) as date_field
FROM table

Then you can pass this directly to PHP's date () function to get the format you want

date('d/M/Y', $row['date_field'])

Answer 5

$d=date_create('2009-12-04 09:15:00');
echo $d->format('dd/M/yyyy');