Hi all,
How do i get first day of next month .
regards
kashi
Printable View
Hi all,
How do i get first day of next month .
regards
kashi
select TO_DATE('01'||TO_CHAR(ADD_MONTHS(SYSDATE,1),'MMYYY Y'),'DDMMYYYY') FROM DUAL
In Words:
Add_monts adds one month to the current date.
From the result we take the month and year oprtion with the to_char statement. Next we concatenate the 1st to the calculated month and year portion and put this back into a date field.
Functions everytime :)