NOTICE

[MSSQL]날짜 변환(datetime)

Date : 2016.07.04 13:08 Category : Programming/SQL

yyyy-mm-dd 형식으로 비교할 때

SELECT * FROM #table WHERE CONVERT(CHAR(10), date_col, 23) = '2016-07-04'