day function

[wsam]

I am trying to find days of the week and group them by those days ie hiredate field grouped by days of the week and am having no luck. Any suggestions.

 

[rcurva]

You can make use of to_char function. As an example, try this:

SELECT TO_CHAR(sysdate,'DAY')
FROM SYS.DUAL;

This would give you the current day of the week in character.

Is this what you want?

SELECT TO_CHAR(hiredate,'DAY') dayofwk, aggregate funcs..
FROM your_table
WHERE criteria here
GROUP BY TO_CHAR(hiredate,'DAY')