I have a varchar2 Oracle field called "" that contains a special date time format "YYYY-MM-DD"T"HH:MM:SS". Ex: 2018-09-02T19:30:00
From that date, i would like to get the day name of it. In above example, "Sun" would be the day of August 2 2018.
I tried multiple TO_CHAR(TO_DATE(DATE_TIME_
START but does not recognize the value as a date. How can i do that?
Select ID, CUSTOMER, DATE_TIME_START from Schedule where DATE_TIME_START = 'SUN'
Thank you for your help