| Query | Run |
|---|---|
| select STR_TO_DATE('20060414231855', '%Y%m%d%H%i%S') | 1 year ago |
| select STR_TO_DATE('20060414 231855', '%Y%m%d %H%i%S') | 1 year ago |
| select STR_TO_DATE('20060414 231855', 'YYYYMMDD HHMMSS') | 1 year ago |
| select STR_TO_DATE('20060414231855', 'YYYYMMDDHHMMSS') | 1 year ago |
| select FROM_UNIXTIME(20060414231855) | 1 year ago |
| select 20060414231855 | 1 year ago |