Query:
SELECT TO_CHAR( TRUNC(SYSDATE),’D’) AS DAY_IN_WEEK FROM DUAL ;
Output :
| DAY_IN_WEEK |
|---|
| 2 |
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:
Output :
Query:
Output :
