MSSQL 명령어

[CONVERT날짜변환]
참고 URL :http://technet.microsoft.com/ko-kr/library/ms187928.aspx

EX)
SELECT * FROM SMS_RESULT
WHERE CONVERT(CHAR(10),JEOBSU_TIME,102) > '2011.02.21'
ORDER BY JEOBSU_TIME DESC;