Hi I was wondering if someone would be kind enough to help me out with the following questions.
I am trying to do a query in mysql that will query a date table for a date entered up to the current date.
For example if a user enters 2006-02-02 I would like to query from 2006-02-02 to todays date.
How would the mysql query look like
select ip_src, ip_dst, sport, dport, timestamp, sig_name from acid_event where timestamp between '2006-01-22%' and ??
how would I tell the following script to search for upto today. Or if there is a better way to do it please advice.
thanks for the help and advice.
Mysql Time query
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users