Forum Stats

  • 3,872,035 Users
  • 2,266,368 Discussions


Can someone just tell me on which columns we can apply to_date() function.

User_J6B4J Member Posts: 1 Green Ribbon

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"



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.