sql - How can I run queries like "within five days" on time series data? -

I would like an easy way to run queries on my time series data like the following query:

"What are the most common occurrences of each of the seven days?"

I can do this by looking at each line and running a query, using SQL and a Java program, which looks up all events seven days ago or later, but this is very Not elegant and the display will be awesome. Is it another way to use SQL or a different query language?

The simplified table structure is similar to the following:

  thetime datetime eventid int magnitude double   
 I specifically describe it Do not want to know what the data is about, because I am looking for a common solution.   
 
 
 You can use one to do something like this yourself. This is a valid syntax for SQL Server, but when you are not using table structure or RDBMS, it is difficult to customize for its installation ...  
  SELECT TOP 10 a. As the 'first event' in the form of an event, B. in the form of 'Second Program' Aven, AAS as ABS (IAT) ('A' Timefield - B. Timefield) as an Inner Manateable B on AIDFiled in MEELAB by 'Time Others' & lt; & gt; BID field WHERE (CAST ((a.timefield - b.timefield ) As INT) and <5