Skip to content

Instantly share code, notes, and snippets.

@halfak

halfak/gist:d80a87ae739ee1b238ff

Created November 18, 2014 19:16
Show Gist options
  • Save halfak/d80a87ae739ee1b238ff to your computer and use it in GitHub Desktop.
Save halfak/d80a87ae739ee1b238ff to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql:[email protected] [enwiki]> SELECT COUNT(*) FROM revision WHERE rev_timestamp BETWEEN "20140101" AND "20140102";
+----------+
| COUNT(*) |
+----------+
| 138753 |
+----------+
1 row in set (0.47 sec)
mysql:[email protected] [enwiki]> SELECT COUNT(*) FROM revision WHERE rev_timestamp BETWEEN "2014-01-01" AND "2014-01-02";
+----------+
| COUNT(*) |
+----------+
| 0 |
+----------+
1 row in set (0.01 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment