USE ruwiki_p;
SELECT
FLOOR(rev_timestamp / 10000000000) as edit_year,
... |
6 years ago |
USE ruwiki_p;
SELECT
FLOOR(rev_timestamp / 10000000000) as edit_year,
... |
6 years ago |
USE ruwiki_p;
SELECT
FLOOR(rev_timestamp / 100000000) % 100 as... |
6 years ago |
USE ruwiki_p;
SELECT
FLOOR(rev_timestamp / 100000000) as edit_month,
... |
6 years ago |