Varchar2 column with a date and time listed as YYYY/MM/DD-HH24:MI:SSFF3
I am more of a beginner in Oracle yet I do some querying on my job. I need to calculate the date only out of this date time varchar2 format(YYYY/MM/DD-HH24:MI:SSFF3). I was able to look at the date only using Regular Expresion but not sure how to pull the date out of this column so that I can do some calculations. The date/time of this varchar2 cannot be changed to a better format.
Is there a way to take the date and place it into another variable to do my calculations. Why they put a 'dash' between the 2 is based on the application they use. I hate dealing with dates in Oracle. This one is a new one to me.
Any help, hints would be appreciated.
Example of the calculations is lastupdate greater than 90days.