What is the recommended method in PHP to change a date format from dd.mm.yyyy to yyyy-mm-dd for MySQL?

When working with dates in PHP and MySQL, it is important to ensure that the date formats match to avoid any issues. To change a date format from dd.mm.yyyy to yyyy-mm-dd for MySQL, you can use the strtotime() and date() functions in PHP. First, convert the original date to a timestamp using strtotime(), then format the timestamp into the desired format using date(). 

$original_date = '25.12.2022';
$new_date = date('Y-m-d', strtotime($original_date));
echo $new_date;

Keywords

PHP date format MySQL date conversion strtotime

Related Questions