Hi
I have a column which is a CHAR(40).
It contains data like 20210930 or data like 2021-08-11 00:00:00.000 +02:00.
I want to convert to a number like 20210930 or 20210811
This works
SELECT TO_NUMBER(TO_CHAR(TO_DATE('20210930','YYYYMMDD'), 'YYYYMMDD')) FROM dual;
How do I convert it to a number like 20210811
I have tried
SELECT TO_NUMBER(TO_CHAR(TO_DATE('2021-08-11 00:00:00.000 +02:00','YYYYMMDD'), 'YYYYMMDD')) FROM dual;
and several variations but always seem to get an error
Ora-01843 Not a valid month
Regards
Gus