How to Change Date Format yyyy-mm-dd to dd-mm-yyyy

Question

When I display date from phpMyadmin to webpage with this code.

date format is showing y-m-d and how to change this in d-m-y

<?php echo $row['dob']; ?>

See [`DateTime`](https://www.php.net/manual/en/class.datetime.php). — Alex Howansky, May 09 '19 at 16:46

score 1 · Answer 1 · answered May 09 '19 at 16:47

1

You can use DATE_FORMAT

SELECT DATE_FORMAT(column_name, '%d/%m/%Y') FROM tablename

answered May 09 '19 at 16:47

Rakesh Jakhar

$originalDate = "2010-03-21"; $newDate = date("d-m-Y", strtotime($originalDate)); i use this code but its showing 12-31-1969 – vikram May 09 '19 at 16:57
This is a better answer, the date string should be formatted when output by MySQL *not* have to be re-processed by PHP after selection. – Martin May 09 '19 at 18:25

1 Answers1