What are the best practices for storing and comparing dates in MySQL databases using PHP?

When storing and comparing dates in MySQL databases using PHP, it is important to use the correct date format and functions to ensure accurate results. It is recommended to store dates in the 'YYYY-MM-DD' format in MySQL's DATE or DATETIME data types. When comparing dates, use MySQL's DATE_FORMAT function to format dates consistently for comparison. 

// Storing a date in MySQL database
$date = date('Y-m-d');
$query = "INSERT INTO table_name (date_column) VALUES ('$date')";
$result = mysqli_query($connection, $query);

// Comparing dates in MySQL database
$dateToCompare = '2022-01-01';
$query = "SELECT * FROM table_name WHERE DATE_FORMAT(date_column, '%Y-%m-%d') = '$dateToCompare'";
$result = mysqli_query($connection, $query);

Keywords

MySQL PHP date comparison storage

Related Questions