[MySql] 날짜로 조회

 

-- DATE 컬럼 변형 O
SELECT *
FROM TABLE_NM
WHERE DATE_FORMAT(DATE_COL_NM, '%Y%m%d') = '20130306'
ORDER BY DATE_COL_NM
;

-- DATE 컬럼 변형 X
SELECT *
FROM TABLE_NM
WHERE 1=1
AND DATE_COL_NM >= STR_TO_DATE('20130306', '%Y%m%d')
AND DATE_COL_NM < DATE_ADD(STR_TO_DATE('20130306', '%Y%m%d'), INTERVAL 1 DAY)
ORDER BY DATE_COL_NM
;