title: Select MySQL rows with timestamp older than 12 hours?
body: <p>In my table <code>monitoring</code>, I want to select the content from the content <code>domain</code>.  But I only want to select it for rows where the timestamp on them is older than 12 hours and it should list the oldest entries first.</p>
  
  <p>Here's what I've got so far and need help with:</p>
  
  <pre><code>SELECT domain FROM monitoring WHERE status = 'active' AND WHERE submit_time = '?????' ORDER BY '?????'
  </code></pre>
  
  <p>I know there are similar questions posted here about this.  However, the answers all seem dependent on the format of your time.  Here's how the time is listed in the database:</p>
  
  <pre><code>01-20-2016 23:12:13
  </code></pre>
  
  <p>Any help would be appreciated.</p>