SELECT
to_char(TRUNC(SysDate,'YEAR'), 'WW')Week_No,
to_char(TRUNC(SysDate,'YEAR'), 'DD/MM/YY')First_Day
FROM dual;
No. | Subject | Author | Date | Views |
---|---|---|---|---|
» | First Day of this year | admin | 2024.03.13 | 297 |
1 | First Day of this month | admin | 2024.02.05 | 366 |