Change date format in php retrieved from mysql

Question

I have a column in mysql which stores the dates. So in mysql the dates are stored in Y-M-D format. However on retrieval i want to view change that format to D-M-Y . I read online at a few places and i found the date() in php, Date conversion. But they are generally for timestamp, also in many cases people had recommended to split the variable by - and then changing position.

My question is that, is splitting the variable the only option here or do we have any built in function that does that for us?

strtotime and date are exactly what you need for this. Unless you explicity create an obscene time string, the strtotime function should accurately parse your date. You should at least try it. — Brian
– Brian, Commented Mar 20, 2012 at 17:00

Saket Patel · Accepted Answer · 2012-03-20 17:03:33Z

this should work for you, check here http://codepad.org/YdZQzgXR

<? $date = '2012-12-30'; echo date('d-m-Y', strtotime($date)); ?>

KARASZI István · Accepted Answer · 2012-03-20 17:02:58Z

You can do that on the PHP side or on the MySQL side.

On the MySQL side you could use DATE_FORMAT:

SELECT DATE_FORMAT(NOW(), '%d-%m-%Y');

or from a field:

SELECT id, DATE_FORMAT(created_at, '%d-%m-%Y') FROM articles;

On the PHP side you have more tools:

use a database abstraction layer (PDO, MDB, etc.)
parse the returned time with strptime and then use strftime to format it
split as you mentioned
...

Niko · Accepted Answer · 2012-03-20 17:01:32Z

2

Two possibilities: PHP's strtotime() or let MySQL do the job!

answered Mar 20, 2012 at 17:01

Niko

26.8k9 gold badges97 silver badges112 bronze badges

Collectives™ on Stack Overflow

Change date format in php retrieved from mysql

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related