Convert date from YYYYMMDD to DD/MM/YYYY format in PHP [duplicate]

Question

I've a MySQL database table in which the date is stored in YYYYMMDD format. Eg: 20121226.

I want to display this date in DD/MM/YYYY format. Eg: 26/12/2012

What I came up with is to use substr to extract the day, month and year separately. I would like to know if there's an easier way to do this.

Also, is there a way to convert this date to "26 December 2012" format without the need to write separate code?

Answer 1

You can easily use the DateTime class to do this

$retrieved = '20121226';
$date = DateTime::createFromFormat('Ymd', $retrieved);
echo $date->format('d/m/Y');

http://php.net/manual/en/datetime.format.php