Jump to content


Photo

Mysql Time query


  • Please log in to reply
1 reply to this topic

#1 mcdrr

mcdrr
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 29 March 2006 - 02:17 AM

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.


#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 29 March 2006 - 05:07 AM

Assuming timestamp is stored in one of the date formats, this should work:

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





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users