select * from TBL_MANUALSIGN where ms_signtiem between to_date('01/01/2012 00:00:00','mm/dd/yyyy hh24:mi:ss') and to_date('02/27/2012 00:00:00','mm/dd/yyyy hh24:mi:ss');
