title: mySQL Workbench Error: Syntax Error, unexpected single quotes
body: <p>I was trying to make a SQL statement in PHP, to convert a string into a time(6). But I have tried everything, for the last 12 hours, and have not made an inch of progress. I have tried these statements, all yield the same error.</p>
  
  <pre><code>UPDATE scheduling SET start='03:42PM' WHERE activityid=2;
  
  UPDATE scheduling SET start=CONVERT(TIME(6),'03:42PM');
  
  INSERT INTO scheduling(start) VALUES (start=CONVERT(TIME(6),'03:42PM')); 
  
  INSERT INTO scheduling(start) VALUES (start=CONVERT(TIME(6),'03:42PM'));
  
  INSERT INTO scheduling(start) VALUES (start=CONVERT(TIME(6),'15:42'));  
  </code></pre>
  
  <p>The error is </p>
  
  <blockquote>
    <p>Syntax Error: unexpected '03:42PM'(single quoted text)"</p>
  </blockquote>
  
  <p>I do not know how to fix this, the table exists, and i have sucesfully got other info using statements like <code>SELECT activityid=2 FROM xxxxxx.scheudling</code></p>
  
  <p>I guess I have two questions, either answer would work.</p>
  
  <ol>
  <li><p>In my PHP document, how would I convert a string I get in from an Android Studio volley to a date. (I get the variable correctly, with <code>$start=$_Post("start")</code>, so that works, but I cant convert it into a time. I looked online, and tried everything that looked like it work work.</p></li>
  <li><p>Conversion through SQL Code, I already tried <code>CAST</code> and <code>CONVERT</code>, neither works. My start column is type <code>TIME(6)</code>.</p></li>
  </ol>