Oracle 19.3 on Win 2019
I have a VARCHAR2 column that used to store dates as "2013-01-27T10:47:09-08:00" by the front end application, but now it's being stored as "12/09/2021 04:58:24 PM"
When I try to retrieve the data, I am getting an error:
SELECT TO_DATE(date_column,'mm/dd/yyyy hh24:mi:ss') FROM T;
ORA-01830: date format picture ends before converting entire input string