mysql 날짜 비교 3가지 방법

-- 명시적 변환
SELECT *
FROM `table_name`
where `is_process` = b'0' and `is_complete` = b'0'
	and `is_publish` = b'1'
	and `create_time` > date('2017-06-08 00:00:00')
-- 명시적 변환 시분초 생략
SELECT *
FROM `table_name`
where `is_process` = b'0' and `is_complete` = b'0'
	and `is_publish` = b'1'
	and `create_time` > date('2017-06-08')
-- 암시적 변환 시분초 생략
SELECT *
FROM `table_name`
where `is_process` = b'0' and `is_complete` = b'0'
	and `is_publish` = b'1'
	and `create_time` > '2017-06-08'