I am trying to fetch records when users query the database useing "MM-DD-YY" date format. The problem is with the format , Oracle recognozes "DD-MON-YY" format and users like "MM-DD-YY" date format, so how do I convert this? I
tried useing to_date(to_char('Pdate','MM-DD-YY'),'MM-DD-YY')
but its not working.
It either says"non numeric character was found where a numeric was expected ORA-01858"
OR "not a valid month"
All I need it users enter date in MM-DD-YY format I need to convert to DD-MOn-YY format as Oracel understands only one format:-(