By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| LEFT('200912301111230000000000',8) | STR_TO_DATE(LEFT('200912301111230000000000',8),'%Y%m%d') |
|---|---|
| 20091230 | 2009-12-30 |
| LEFT('200912301111230000000000',8) | STR_TO_DATE(LEFT('200912301111230000000000',8),'%Y%m%d') |
|---|---|
| 20091230 | 2009-12-30 |