I used SELECT TO_DATE(INC_DATE, 'MMDDYYYY') FROM BASICINCIDENT2010;but since not all the dates in the inc_date are of the same format. It causes the error of Month not found.
SELECT TO_DATE(INC_DATE, 'MMDDYYYY') FROM BASICINCIDENT2010;
Aucun commentaire:
Enregistrer un commentaire