SELECT rows where seconds since epoch from NOW <p>I am wondering is there a way to select only rows where time since epoch and "now()" is greater than a certain amount of seconds.</p> <p>I store the rows with a field holding seconds since epoch created from the php function <code>time()</code>.</p> <p>So something like this:</p> <p><code>SELECT * FROM table WHERE (now - field_time) &gt; 60 seconds</code></p>