Query Run
SELECT SUBSTRING(rev_timestamp,1,8) as date FROM revision LIMIT 100 2 years ago
SELECT SUBSTRING(rev_timestamp AS STRING,0,8) as date FROM revision LIMIT 100 2 years ago
SELECT SUBSTRING(rev_timestamp,0,8) as date FROM revision LIMIT 100 2 years ago