SELECT SUBSTRING(a.receiveTime,0,20) formatReceiveTime, a.receiveTime FROM your_table_name a https://www.leftso.com/article/93.html
SELECT SUBSTRING(a.receiveTime,0,20) formatReceiveTime, a.receiveTime FROM your_table_name a https://www.leftso.com/article/93.html