title: 1292: Incorrect datetime value: '' for column at row 1
body: <p>I am trying to load data from excel sheet to the below table on MYSQL 5.6 on windows 8.1 and I am getting 'Incorrect datetime value:' error. </p>
  
  <p>Term date column is of DATETIME data type and the data has null values in the excel sheet which I am trying to insert into the table.</p>
  
  <p>I did some research and found that the problem is with the SQL strict mode. But I am not able to figure out how to disable or modify the SQL strict mode. </p>
  
  <p>I in fact tried this <code>SET SESSION sql_mode='ALLOW_INVALID_DATES'</code> but no luck. </p>
  
  <p>Some said editing my.ini file in installation directory will help but I am not able to find it in the installation directory.</p>
  
  <p>can any one please help me resolve this issue. </p>
  
  <pre><code>create table EMPLOYEE(EMP_ID integer(10),
  EMP_NAME char(25),
  SALARY integer(25),
  START_DATE datetime,
  TERM_DATE datetime DEFAULT '1900-01-01',
  PRIMARY KEY (EMP_ID));
  </code></pre>
  
  <p>Error Message:</p>
  
  <pre><code>15:23:08    INSERT INTO `mith`.`EMPLOYEE` (`EMP_ID`, `EMP_NAME`, `SALARY`, `START_DATE`, `TERM_DATE`) VALUES ('26', 'Will Banker', '90000', '00:00.0', '')  1292: Incorrect datetime value: '' for column 'TERM_DATE' at row 1  
  </code></pre>