How can PHP functions like strtotime() be used effectively to handle date formatting from CSV files?

When handling date formatting from CSV files in PHP, the strtotime() function can be used effectively to convert date strings into Unix timestamps, making it easier to manipulate and format dates as needed. By using strtotime(), you can easily parse and convert various date formats found in CSV files into a standardized format for further processing. 

// Sample CSV data with dates in different formats
$data = [
    ['John Doe', '12/25/2021'],
    ['Jane Smith', '2022-01-15'],
];

foreach ($data as $row) {
    $name = $row[0];
    $date = strtotime($row[1]); // Convert date string to Unix timestamp
    $formatted_date = date('Y-m-d', $date); // Format date as needed
    echo "Name: $name, Date: $formatted_date\n";
}

Keywords

PHP strtotime() date formatting CSV files handling dates

Related Questions