Change type of date in html table - php mysql

Question

I need some help with converting the date to dd/mm/YYYY.

I have this code to display my date in a html table from a mysql database

echo "<td>".$zeile['datumFahrt']."</td>";

Can I convert it in this line so the format will be dd/mm/YYYY instead of YYYY/mm/dd?

No im storing it as date. Just need it to display as dd/mm/YYYY — Manuel Mahler, Sep 05 '16 at 20:49
Okay, with the question update what about using the `date` function? http://php.net/manual/en/function.date.php Demo: https://eval.in/635581 — chris85, Sep 05 '16 at 20:49

MoeinPorkamel · Answer 1 · 2016-09-05T20:55:42.313

4

Sure you can, first you need to convert it to timestamp and then format it:

date("d/m/Y", strtotime($zeile['datumFahrt']))

edited Sep 05 '16 at 20:55

answered Sep 05 '16 at 20:51

MoeinPorkamel

`dd/mm` is going to double the day and month output. – chris85 Sep 05 '16 at 20:52
@chris85 Damn you right, edited. – MoeinPorkamel Sep 05 '16 at 20:55
1

[`strftime`](http://php.net/manual/en/function.strftime.php) pairs well with `strtotime` – tadman Sep 05 '16 at 21:03

1 Answers1