Select MySQL rows with timestamp older than 12 hours? : <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>
