title: Data truncation-Incorrect date value when trying to insert a time
body: <p>My Insert statement</p>
  
  <pre><code>INSERT INTO tblData_FY14 
  VALUES (STR_TO_DATE('24/07/2013','%d/%m/%Y'), 
          STR_TO_DATE('14:31:07','%h:%i:%s'), 
          STR_TO_DATE('14:31:20','%h:%i:%s'), 
          1, 1, 2, 3, 4, 13)
  </code></pre>
  
  <p>The error I get:</p>
  
  <pre><code>com.mysql.jdbc.MysqlDataTruncation: Data truncation:
           Incorrect date value: '14:33:21' for column 'TimeofStop' at row 1
  </code></pre>
  
  <p>I can't work out why I'm getting the error, as far as I can see the format is correct...</p>
  
  <p>I had the same issue with the date before this, but managed to solve it googling for the correct format, but my efforts for this time issue have come to nothing so far</p>
  
  <p>EDIT
  see the C# code for creating this table:</p>
  
  <pre><code>MySqlCommand command = new MySqlCommand("CREATE TABLE IF NOT EXISTS tblData" + GVars.curFY +
                          " (" +
                          "DateofStop DATE, " +
                          "TimeofStop DATETIME, " +
                          "TimeofStart DATETIME, " +
                          "CategoryID INT REFERENCES tblDtCategory(CategoryID), " +
                          "DowntimeID INT REFERENCES tblDowntime(DowntimeID), " +
                          "AreaID INT REFERENCES tblMachineArea(AreaID), " +
                          "ProblemID INT REFERENCES tblProblem(ProblemID), " +
                          "CauseID INT REFERENCES tblCause(CauseID), " +
                          "DowntimeSeconds INT);", dbConn);
  </code></pre>
  
  <p>The type of "TimeofStop" and "TimeofStart" are datetime
  However, the mySQL command prompt shows them as DATE, is this the problem? What type should I set them to?</p>