PL/SQL CODE

First Day of this year

admin 2024.03.13 23:15 Views : 745 

SELECT 
to_char(TRUNC(SysDate,'YEAR'), 'WW')Week_No,
to_char(TRUNC(SysDate,'YEAR'), 'DD/MM/YY')First_Day

FROM dual;
I want to
List
No. Subject Author Date Views
» First Day of this year admin 2024.03.13 745
1 First Day of this month admin 2024.02.05 1383
Write Tag