 <p>You may be able to do something with <code>ROUND</code> and a negative rounding value, which will round to the left of the decimal rather than the right. For example, the dates in your results will look like this if you use <code>ROUND(date, -1)</code>:</p> <pre><code>date round(date, -1) ---------- --------------- 1318763642 1318763640 1318763643 1318763640 1318763639 1318763640 1318763641 1318763640 1318763637 1318763640 1318763640 1318763640 1366200434 1366200430 </code></pre>