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  小歹毒  阅读(227)  评论(0)    收藏  举报