Date conversion problem

[moyoal]

Dear All,

Help me!

From application i am sending date parameter to report which is in 'DD-MON-RRRR' format...

In a table i have a column TRX_DATE in want to compare this column with Form date parameter

when i check report argument its something like this

 
p_ca_set_of_books_id='1'
P_SET_OF_BOOKS_ID='1'
P_ORDER_BY='Customer'
P_CUSTOMER_NUMBER_LOW='1001'
P_CUSTOMER_NUMBER_HIGH='1005'
P_START_DATE='2001/01/01 00:00:00'
P_END_DATE='2005/01/01 00:00:00'
 
Receiving an error while running the report.
 
ERR REP-1401: 'afterpform': Fatal PL/SQL error occurred.
ORA-01861: literal does not match format string
 
if :p_start_Date is NOT NULL then 
:lp_start_date := TO_CHAR(to_date(:p_start_date),'DD-MON-RRRR');
end if ;
 
if :p_end_date is NOT NULL then 
    :lp_start_date := TO_CHAR(to_date(:p_end_date),'DD-MON-RRRR');
end if ;
 

please help me how do i compare my arguments with table column...

regards,
moyoal

[amitpatel66]

You need to try something like this:

 
if :p_start_Date is NOT NULL then 
:lp_start_date := TO_CHAR(to_date(:p_start_date),'RRRR/MM/DD HH24:MI:SS');
end if ;
 
if :p_end_date is NOT NULL then 
    :lp_start_date := TO_CHAR(to_date(:p_end_date),'RRRR/MM/DD HH24:MI:SS');
end if ;
 
 

[moyoal]

thanks for your reply amit....
i will try will back to you
regards

You need to try something like this:

 
if :p_start_Date is NOT NULL then 
:lp_start_date := TO_CHAR(to_date(:p_start_date),'RRRR/MM/DD HH24:MI:SS');
end if ;
 
if :p_end_date is NOT NULL then 
    :lp_start_date := TO_CHAR(to_date(:p_end_date),'RRRR/MM/DD HH24:MI:SS');
end if ;