title: Writing dates with RMySQL
body: <p>I have a time in R which I would like to write to a MySQL table in a DATETIME column. How can I do that? If I format it as a string SQL doesn't recognize it; if I use <code>as.POSIXlt</code> SQL still doesn't recognize it.</p>
  
  <p>I'm just using standard <code>dbConnect</code> and <code>dbWriteTable</code> statements, which work with non-dates just fine.</p>