mysql 日期字符串转换
1.字符串转时间
SELECT STR_TO_DATE("2021-02-20", "%Y-%m-%d") FROM DUAL;2.时间转字符串
SELECT DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s') FROM DUAL;1.字符串转时间
SELECT STR_TO_DATE("2021-02-20", "%Y-%m-%d") FROM DUAL;2.时间转字符串
SELECT DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s') FROM DUAL;