Oracle Transactional Business Intelligence

Products Banner

Day Name from Date

Received Response
72
Views
5
Comments

Summary

Need to get the name of the day of the week from the Creation Date

Content

Hello,

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?

Thanks,

Stephanie

Answers