What are the benefits of adding a "ganztag" column in a MySQL table for date-related tasks in PHP?

When working with date-related tasks in PHP, it can be beneficial to add a "ganztag" column in a MySQL table to store whether an event or task is an all-day event or not. This column can be a boolean field, where 1 represents a full-day event and 0 represents a specific time event. This can help in filtering and displaying events differently based on their duration.

// Sample SQL query to create a table with a "ganztag" column
$sql = "CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_name VARCHAR(255) NOT NULL,
    event_date DATE NOT NULL,
    ganztag TINYINT(1) NOT NULL
)";

// Execute the query
mysqli_query($conn, $sql);