[ale] Indexing datetime field in mysql?

James Sumners james.sumners at gmail.com
Tue Aug 9 22:59:49 EDT 2005


Oops, I forgot to remove the '>'.

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
> http://james.roomfullofmirrors.com/
> 
> "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
http://james.roomfullofmirrors.com/

"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



More information about the Ale mailing list