select DATE_FORMAT(a.OPERATE_TIME,'%Y-%m-%d %H:%i:%s') AS OPERATE_TIME
结果:2021-03-24 15:40:59
参考文章:
http://www.360doc.com/content/19/0404/10/40984640_826349929.shtml
select DATE_FORMAT(a.OPERATE_TIME,'%Y-%m-%d %H:%i:%s') AS OPERATE_TIME
结果:2021-03-24 15:40:59
参考文章:
http://www.360doc.com/content/19/0404/10/40984640_826349929.shtml