Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
IKhitron
.
Toggle Highlighting
SQL
use hewiki_p; set @startdate = "2015-11-11"; set @stopdate = "2015-11-17"; set @newstartdate = date_add(concat(@startdate, " 00:00:00"), interval 3 hour); set @newstopdate = concat(@stopdate, " 00:00:00"); select @newstartdate, @newstopdate; #elect rev_timestamp from revision #here datediff("2015-11-10 14:52:59", rev_timestamp) > 0 #nd datediff("2015-11-05 14:52:59", rev_timestamp) < 0 #imit 10; #SET time_zone ='+03:00'; #select concat(substring("20151110145259", 1, 4), '-', substring("20151110145259", 5, 2), '-', substring("20151110145259", 7, 2), ' ', #substring("20151110145259", 9, 2), ':', substring("20151110145259", 11, 2)); #select rev_timestamp, convert_tz(rev_timestamp,'GMT','MET') from revision limit 10; #ELECT now(), DATE_ADD(20030104002633, INTERVAL 3 HOUR) #where datediff("2015-11-10 14:52:59", rev_timestamp) > 0 #and datediff("2015-11-05 14:52:59", rev_timestamp) < 0 #order by rev_timestamp desc #limit 10
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...