Jump to content

Archived

This topic is now archived and is closed to further replies.

mcdrr

Mysql Time query

Recommended Posts

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.

Share this post


Link to post
Share on other sites
Assuming timestamp is stored in one of the date formats, this should work:

[code]select ip_src, ip_dst, sport, dport, timestamp, sig_name from acid_event where timestamp between '2006-01-22' and CURDATE()[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.