Get the day number in week in sql

In this article we wre going write a query to find day number in the current week. See the below query.

Query:

SELECT TO_CHAR( TRUNC(SYSDATE),'D') AS DAY_IN_WEEK  FROM DUAL ;

Output :

DAY_IN_WEEK
2