Forum Stats

  • 3,815,939 Users
  • 2,259,117 Discussions
  • 7,893,336 Comments

Discussions

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

User_J6B4J
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"

*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.

Answers