title: MySQL upgrade5.5 to 5.6, date code broken
body: <p>I'm facing an issue after upgarde MySQL from v5.5 to 5.6,
  I have copied the DB from 5.5 to 5.6 version, all seems working fine except date functions:
  <strong>example:</strong>
  <code>select count(*) from mybooking_testing.testtable where NOW() NOT BETWEEN testtable.orderDateFrom AND testtable.orderDateTO and testtable.id = 176544</code> returning 1 in MySQL5.5 while 0 in MySQL 5.6.
  <em>Note: Both orderDateFrom and orderDateTO are null</em></p>
  
  <p>This issue is breking my whole code in production and wanted to fix it by MySQL only not by code.</p>
  
  <p>I have tried SQL_MODE workaround set SQL_MODE ="" with no success.</p>
  
  <p>any help will be appreciated!!</p>