Entry

How can I select rows from a database with a field between two dates?

Jan 25th, 2000 22:15
Nathan Wallace, Martin Koistinen

MySQL supports the between operator for the DATE field.

    SELECT *
    FROM   Appointments 
    WHERE  Moment BETWEEN StartTime AND EndTime ORDER BY StartTime;