[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[no subject]
- <!--x-content-type: text/plain -->
- <!--x-date: Tue, 9 Aug 2005 22:59:49 -0400 -->
- <!--x-from-r13: wnzrf.fhzaref ng tznvy.pbz (Xnzrf Ehzaref) -->
- <!--x-message-id: [email protected] -->
- <!--x-reference: [email protected] -->
- <!--x-reference: [email protected] --> "http://www.w3.org/TR/html4/loose.dtd">
- <!--x-subject: [ale] Indexing datetime field in mysql? -->
- <li><em>date</em>: Tue, 9 Aug 2005 22:59:49 -0400</li>
- <li><em>from</em>: james.sumners at gmail.com (James Sumners)</li>
- <li><em>in-reply-to</em>: <<a href="msg00103.html">[email protected]</a>></li>
- <li><em>references</em>: <<a href="msg00101.html">[email protected]</a>> <<a href="msg00103.html">[email protected]</a>></li>
- <li><em>subject</em>: [ale] Indexing datetime field in mysql?</li>
On 8/9/05, James Sumners <james.sumners at gmail.com> wrote:
> SELECT st_time, INET_NTOA(src_ip) as source, INET_NTOA(dst_ip) as dest
> FROM ff.flow WHERE st_time BETWEEN > '2005-07-01 23:55:55' and
> '2005-08-08 00:00:00' AND proto = '6' ORDER BY source ASC;
>
> You might also want to specify the table that it should be pulling
> st_time from; something like "source.st_time".
>
> --
> James Sumners
> <a rel="nofollow" href="http://james.roomfullofmirrors.com/">http://james.roomfullofmirrors.com/</a>
>
> "All governments suffer a recurring problem: Power attracts
> pathological personalities. It is not that power corrupts but that it
> is magnetic to the corruptible. Such people have a tendency to become
> drunk on violence, a condition to which they are quickly addicted."
>
> Missionaria Protectiva, Text QIV (decto)
> CH:D 59
>
--
James Sumners
<a rel="nofollow" href="http://james.roomfullofmirrors.com/">http://james.roomfullofmirrors.com/</a>
"All governments suffer a recurring problem: Power attracts
pathological personalities. It is not that power corrupts but that it
is magnetic to the corruptible. Such people have a tendency to become
drunk on violence, a condition to which they are quickly addicted."
Missionaria Protectiva, Text QIV (decto)
CH:D 59
</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00101" href="msg00101.html">[ale] Indexing datetime field in mysql?</a></strong>
<ul><li><em>From:</em> kboateng_cs at yahoo.com (Kofi Boateng)</li></ul></li>
<li><strong><a name="00103" href="msg00103.html">[ale] Indexing datetime field in mysql?</a></strong>
<ul><li><em>From:</em> james.sumners at gmail.com (James Sumners)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00103.html">[ale] Indexing datetime field in mysql?</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00105.html">[ale] Mail System Error - Returned Mail</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00103.html">[ale] Indexing datetime field in mysql?</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00105.html">[ale] Mail System Error - Returned Mail</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00104"><strong>Date</strong></a></li>
<li><a href="threads.html#00104"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>
<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>