How to find first
Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday of the month in Oracle
PL SQL.
To do so I
used Next_day and Trunc functions of Oracle PL SQL
Select NEXT_DAY(
TRUNC(sysdate, 'MM') - 1 , 'Sunday') from dual;
By changing sysdate to any particular date and Sunday to any
week days, you will find that months mentioned first week day.
No comments:
Post a Comment