What is the default date format in PHP for MySQL databases?

When working with MySQL databases in PHP, the default date format is 'Y-m-d H:i:s' (Year-Month-Day Hour:Minute:Second). If you need to format dates differently, you can use the PHP date() function to specify a custom format. 

// Set the default timezone
date_default_timezone_set('UTC');

// Get the current date and time in the default MySQL format
$currentDateTime = date('Y-m-d H:i:s');

echo $currentDateTime;

Keywords

PHP MySQL default date format databases date conversion

Related Questions