Because I have a column called hire_dt in my table with 'DD-MM-YYYY' format. Now if i want to change format and when every i am running below query
select To_date(HIRE_DATE,'DDMMYYYY') as Result from Emp1719; I am getting an error like.
ORA-01843: not a valid month
01843. 00000 - "not a valid month"
*Cause:
*Action:
Can someone help me on this please.
And I also want to know exact functionality of to_date, as i didnt find correct info on any site. and on what kind on columns we can apply to_date function.