Select * from dqc342 Where Location= 'A9T80-60008 ' and TEST_DTTM between to_date('20161121000000','yyyymmdd hh24miss') and to_date('20161121 235959','yyyymmdd hh24miss')