Oracle Transactional Business Intelligence
Day Name from Date
Need to get the name of the day of the week from the Creation Date
I am using this function: DAYNAME("Service Request"."Creation Date") and it is not returnning the day NAME I would expect. It is returning a number. So for Sunday it returns "1", Monday, "2", and so on so forth. I don't want to display the day number of the day of week. i want to display the Name. Sunday, Monday, Tuesday, etc. Does anybody know how to do that?