title: CONVERT or CAST field in SQL Query
body: <p>I have a TimeStamp field in a MySQL database that I'm trying to pull data from. I'm trying to get it as a string, so I've been using the following query:</p>
  
  <p><code>select CONVERT(VARCHAR, date_created, 120) from junk;</code></p>
  
  <p>It throws the error:</p>
  
  <p><code>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR, date_modified, 120) from junk limit 10' at line 1</code></p>
  
  <p>Can someone please tell me what I'm doing wrong?</p>