This issue was converted from https://jira.toolserver.org/browse/DBQ-100.
Summary: Shortening time intervals in queries related to time
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: (none)

From: Taha Yasseri <taha.yasseri@theorie.physik.uni-goettingen.de>

Date: Thu, 02 Sep 2010 15:42:00

Hello,
I would like to modify some of the existing queries in a way that they work and give the output in smaller time intervals. For example there is the query which counts the number of deletions per day, now how can I change it (probabily the line "DATE(CONCAT(YEAR(log_timestamp),"<del>",MONTH(log_timestamp),"</del>",DAY(log_timestamp))) AS day,")
to get the number of deletions per hour, or minute, etc.?

Bests,
Adler

Version: unspecified
Severity: major