Today I met a storage problem, there is a into the parameter value is called in_date, format '20201011' means on October 11, 2020, but the input is a string, how can I put my input string into the corresponding date format, bosses, I tried to string - "(substr (in_date, 1, 4)) | | '/' (substr (in_date, 5, 2) | | '/' (substr (in_date, 7, 2))) show that is invalid, please bosses, teaching skill, such as online

CodePudding user response:

The select to_date (' 20201011 ') from dual;
The select to_date (' 20201011 ', '- dd yyyy - mm) from dual;

CodePudding user response:

I need to join into the parameter is not a fixed value to_date how to add variables in it