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