cast 

SELECT CAST(CONVERT(CHAR(10),CURRENT_TIMESTAMP,102) AS DATETIME)

SELECT CONVERT(CHAR(10),CURRENT_TIMESTAMP,102) AS DATETIME

posted @ 2013-04-05 11:44  小歹毒  阅读(205)  评论(0)  编辑  收藏  举报