date function

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 :)