SQL & PL/SQL

Hi All,

I am getting an issue while generating the data between 2 dates. For from column i am giving a date of 10/2/2014 and for the to column im giving a date of 10/3/2014. The data should be between these two dates. In the final output 10/3/2013 is also getting included in the report. Could you please solve this issue. I am using the below piece of code for this extract in pl/sql

IF (to_date(p_Frm_Dt,'MM/DD/YYYY') IS NOT NULL OR TRIM(p_Frm_Dt) <> '') AND (to_date

(p_To_Dt,'MM/DD/YYYY') IS NOT NULL OR TRIM(p_To_Dt) <> '') THEN

                   if flagToWhere = '1' THEN

                         query_str:= query_str || ' WHERE CRTE_TS between ''' || to_date(p_Frm_Dt,'MM/DD/YYYY')  ||  ''' and ''' || to_date

(p_To_Dt,'MM/DD/YYYY')+1  ||  '''';

                   else

                         query_str:= query_str || ' WHERE CRTE_TS between ''' || to_date(p_Frm_Dt,'MM/DD/YYYY')  ||  ''' and ''' || to_date

(p_To_Dt,'MM/DD/YYYY')+1  ||  '''';

                      --query_str:= query_str || 'WHERE TO_CHAR(CRTE_TS,''MM/DD/YYYY'') between  ''01/07/2013'' and ''01/08/2013''';

                          --flagToWhere := '1';

                       END IF;

                END IF;

Below is the output i am getting for the above mentioned dates.

Looking forward for your suggestions.