How to convert any kind of date that comes in any format from the user to 'yyyymmdd' in Oracle?

todeepakmalhotra

 Profile Answers by todeepakmalhotra Questions by todeepakmalhotra

• Nov 24th, 2008

To convert a date in a specified format you need to convert it into character..select to_char(hire_date, 'yyyymmdd') date from employees;

Answer Question  Select Best Answer