In this article we wre going write a query to find day number in the current week. See the below query.
Query:
Output :
Query:
SELECT TO_CHAR( TRUNC(SYSDATE),'D') AS DAY_IN_WEEK FROM DUAL ;
Output :
DAY_IN_WEEK |
---|
2 |