KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a date column in a table stored as MM/DD/YYYY format. I have to select and store the same date in another table in YYYY-MM-DD format i.e. XSD Date Format. But I am not able to do it. I am using this query: select to_date(date_column,'YYYY-MM-DD') from table; But still I am not able to do it. Giving me error ORA-01843 : not a valid month
Tags (comma-separated)
Save Edits
Cancel