where hiredate >= to_date('2006-01-01','YYYY-MM-DD')
and hiredate < to_date('2006-01-02','YYYY-MM-DD')