Adding time to curdate mysql <p>I have two columns, one is a datetime, and another is a time. I need to add to the time column the CURDATE(), and compare with the datetime column.</p> <pre><code>SELECT b.rese_data, a.period_ini, a.period_end FROM esp_time a, rese b WHERE a.week_day = WEEKDAY(NOW()) AND a.period_ini &lt;= NOW() AND a.period_end &gt;= NOW() AND b.rese_data &gt;= a.periodo_ini AND b.rese_data &lt;= a.periodo_fim </code></pre> <p>First i select the two period(time) which can be like :</p> <pre><code>period_ini = "12:00:00" pediod_end = "17:00:00" </code></pre> <p>and then compare with the rese_data(datetime)</p>