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