https://bugzilla.wikimedia.org/show_bug.cgi?id=59352
Web browser: --- Bug ID: 59352 Summary: DBQ-100 Shortening time intervals in queries related to time Product: Tool Labs tools Version: unspecified Hardware: All OS: All Status: NEW Severity: major Priority: Unprioritized Component: Database Queries Assignee: wmf.bugconver...@gmail.com Reporter: wmf.bugconver...@gmail.com Classification: Unclassified Mobile Platform: --- 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.yass...@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 -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l