In production database nls_date format is dd-mon-rr and we have oracle application server forms and reporrs. Now when we run report we enter date in dd-mm-rr format so its give error unable to run report bcz of type mis match of database and coding level format.
Is there any possibility database format remain as it is but in report we can enter any kind of date format output like 15-05-2015 or 15-may-201and we can run report successfully.
Is there any way? Thanks in advance.