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