Date-related operations are currently used

Date-related operations are currently used. 1. Obtain the date of the current week and Monday.

select trunc(sysdate, 'yyyy') - to_char(trunc(sysdate, 'yyyy'), 'd') - 5 +       (select to_char(sysdate, 'ww') from dual) * 7 startweek  from dual;

 

2. Obtain the date of the current week and Sunday.

select trunc(sysdate, 'yyyy') - to_char(trunc(sysdate, 'yyyy'), 'd') + 1 +       (select to_char(sysdate, 'ww') from dual) * 7 as endweek  from dual;

 

3. Date representation in Oracle:

   select to_char(sysdate,'CC WW W D DDD YYYY/MM/DD year month day') FROM DUAL

 

CC is the week WW, the week W in a year, and the week D in a month is the day of the week DDD in a year, the year month is the day of the week 4. today is the week of the month.

    select to_char(sysdate,'ww')-to_char(trunc(sysdate,'MM'),'WW')+1 weekOfMon from dual;