Could you please help me in converting date from the format “20120101” to DATE format in Orcle Sql.
I looked at this link but it does not mention if the date format is custom..
EDIT: Is it possible to write any exclusion rule to the conversion function?
something like this “99999999” to “9999-12-31”? Is it possible?
SELECT to_date('20120101','YYYYMMDD') FROM dual;