| select rev_timestamp, SUBSTR(rev_timestamp, 0, 4)
from revision
WHERE... |
2 years ago |
| select rev_timestamp, SUBSTRING(rev_timestamp, 0, 4)
from revision
WHERE... |
2 years ago |
| select rev_timestamp, substring(rev_timestamp, 0, 4)
from revision
WHERE... |
2 years ago |
| select substring(rev_timestamp, 0, 4)
from revision
WHERE rev_timestamp like '2003%' |
2 years ago |
