What are some common methods to extract individual date components from a date field retrieved from a MySQL database in PHP?

When retrieving a date field from a MySQL database in PHP, you may need to extract individual date components such as year, month, and day for further processing or display. One common method to achieve this is by using the `date()` function in PHP along with `strtotime()` to convert the retrieved date string into a Unix timestamp. 

// Retrieve date field from MySQL database
$dateFromDB = "2022-01-15";

// Convert date string to Unix timestamp
$timestamp = strtotime($dateFromDB);

// Extract individual date components
$year = date('Y', $timestamp);
$month = date('m', $timestamp);
$day = date('d', $timestamp);

// Output individual date components
echo "Year: " . $year . "<br>";
echo "Month: " . $month . "<br>";
echo "Day: " . $day . "<br>";

Keywords

PHP MySQL date field date components extraction

Related Questions