| Query | Run |
|---|---|
| select concat(year(now())-1,0101000000) | 3 years ago |
| select concat(year(now())-1,"0101000000") | 3 years ago |
| select concat(year(now()),"0101000000") | 3 years ago |
| select concat(year(now()),"010100000000") | 3 years ago |
| select year(now()) | 3 years ago |
| select now() | 3 years ago |