On 8/11/07, shawn bright &lt;<a href="mailto:nephish@gmail.com">nephish@gmail.com</a>&gt; wrote:<br>&gt; lo there all,<br>&gt; <br>&gt; is there a way i can use find where `date_time` between &#39;2007-07-21<br>&gt; 01:23:25&#39; and &#39;2007-07-24 01:23:25&#39; ?
<br>&gt; <br>&gt; how would i construct that ?<br>&gt; <br>&gt; like <br>&gt; sensor_hit = store.find(SensorHit, ..... don&#39;t know what to put here <br><br>Probably something like<br><br><span style="font-family: courier new,monospace;">
store.find(SensorHit,</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SensorHit.date_time &gt; &#39;2007-07-21 01:23:25&#39;,</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SensorHit.date_time &lt; &#39;2007-07-24 01:23:25&#39;)</span><br style="font-family: courier new,monospace;"><br>You can also use &lt;= and &gt;= if you want an inclusive range.
<br><br>-- <br>Christopher Armstrong<br>International Man of Twistery<br><a href="http://radix.twistedmatrix.com/">http://radix.twistedmatrix.com/</a><br><a href="http://twistedmatrix.com/">http://twistedmatrix.com/</a><br>
<a href="http://canonical.com/">http://canonical.com/</a><br><br>