EXPLAIN SELECT DEST_PHONE T_PHONE ,REQUEST_TIME T_DATE ,MSG_BODY T_MSG FROM uds_log WHERE REQUEST_TIME BETWEEN '2009-10-01 00:00:00' AND '2009-10-01 23:59:59'
또는 WHERE REQUEST_TIME BETWEEN CONVERT('2009-10-01 00:00:00' , DATETIME) AND CONVERT('2009-10-01 23:59:59' , DATETIME) 똑같은 결과
EXPLAIN SELECT DEST_PHONE T_PHONE ,REQUEST_TIME T_DATE ,MSG_BODY T_MSG FROM uds_log WHERE REQUEST_TIME LIKE '2009-10-01 %'