I like using because it seems to be more efficient that is according to a query plan. WHERE a.date AND date는 WHERE 절에 다시 날짜, 오전, 오전을 썼습니다. WHERE a.date AND date wrote Re Dates in a WHERE clause , AM On Nov , am, dg wrote Recently SQL and Sybase have introduced DATE and TIME datatypes.