What's the output select to_Date('2009-may-25','yyyymmdd') from dual
20090525
Error
2009-may-25
may-25-2009