How Can I Convert String Value To Date
I have the following string values in a column- For example: 2017-19, 2017-20, 2017-21.....
This ist Year-week. How can i convert this value in date values so that the database understands everything as a date and can make different calculations later.
I have tried with cast and STR_TO_DATE but without success. At the end I need these string values in the format % Y-% v. Has someone experience with it ? Thanks for the answer
Subject
Written By
Posted
How Can I Convert String Value To Date
January 13, 2018 02:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.