How to convert datetime stored in MySQL, to a different format using php

Question

I have date stored in MySQL DB using CURRENT_TIMESTAMP as default, so that when a new data is inserted the date and time is stored automatically. And, I want to retrieve this data and display in my PHP. The retrived data looks like this 2019-03-17 15:02:36 .

Now I need to change it to March 17 2019 in my output.

I tried using date_format() but it is not displaying any output. It just returns blank data.

How can I achieve this.

Hint: Try it in your statement like `DATE_FORMAT (erstelltam, \"%dth %b %Y at %H:%i:%S Uhr\") AS erstelltam — Kerim Yagmurcu
– Kerim Yagmurcu, Commented Mar 17, 2019 at 10:41

Dave · Accepted Answer · 2019-03-17 10:48:17Z

1

The DateTime functions of PHP to the rescue.

$sqldate = '2019-03-17 15:02:36';
$sqldate = DateTime::createFromFormat('Y-m-d G:i:s',$sqldate);
echo $sqldate->format('F d Y');

Produces:

March 17 2019

answered Mar 17, 2019 at 10:48

Dave

5,19717 gold badges34 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Khurram Shaikh · Accepted Answer · 2019-03-17 10:49:44Z

1

Its quite simple use below code

SELECT *, DATE_FORMAT(YOURDATECOLUMN,'%d/%m/%Y') AS niceDate 
FROM table 
ORDER BY YOURDATECOLUMN DESC

Fiddle : http://sqlfiddle.com/#!9/9eecb/82244

answered Mar 17, 2019 at 10:49

Khurram Shaikh

3003 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to convert datetime stored in MySQL, to a different format using php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related