SQL SERVER数据库中SUBSTRING函数的使用
SELECT SUBSTRING(a.receiveTime,0,20) formatReceiveTime, a.receiveTime FROM your_table_name a