vendredi 29 juillet 2016

Convert MDDYYYY and MMDDYYYY column to MM-DD-YYYY in Oracle SQL

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.

Aucun commentaire:

Enregistrer un commentaire