This content has been marked as final. Show 3 replies
1 of 1 people found this helpful
RUN_DATE value is like 20190304?
in that case you need to use to_char to convert to date format as mm/dd/yyyy'
and then convert the output to date using to_date
So would it be like this?
TO_DATE(to_char(RUN_DATE ,'mm/dd/yyyy '),'mm/dd/yyyy')