title: How to format date and time values for SQLite?
body: <p>Can't believe I have to ask this here. Even googling didn't help.</p>
  
  <p>I want to do this:</p>
  
  <pre><code>insert into atable (adatefield,atimefield,adatetimefield) values (A,B,C);
  </code></pre>
  
  <ul>
  <li>adatefield is defined as DATE</li>
  <li>atimefield is defined as TIME</li>
  <li>adatetimefield is defined as DATETIME</li>
  </ul>
  
  <p>What do I put for A, B and C?</p>
  
  <p>It's nice that it's free but the documentation for SQLite is awful.</p>