SQL SERVER数据库中SUBSTRING函数的使用
SELECT SUBSTRING(a.receiveTime,0,20) formatReceiveTime, a.receiveTime FROM your_table_name a
sql SUBSTRING sql server http://blog.xqlee.com/article/93.html