I am getting this erro ORA-01843 not a valid month.
I am trying to convert the date from MM-DD-YYYY format to DD-MON-YY its giving me this error. Does anyone have any idea what to do to fix it?
The user enters the date in MM-DD-YYYY format whereas in database the date format is DD-MON-YY. I need to get the sum amount when the date's are equal.
here is the query..
select sum(payin_amount) from ts_direct_payins
where payin_Date = to_date('02-27-2002','MM-DD-YYYY')
and cr_dr_flag ='D'
This works fine in SQL but not on FORMS.
Please let me know at the earlist.