In my earlier post i show one method of retrieving first day of a month by oracle built in function, which is ADD_MONTHS.
Now i show another method. Write the following code and get the megic.
SELECT TO_DATE(TO_CHAR(SYSDATE,'MONRRRR'),'MONRRRR')
FROM DUAL
Helpful ? Need more stuff. just leave you comments.
Now i show another method. Write the following code and get the megic.
SELECT TO_DATE(TO_CHAR(SYSDATE,'MONRRRR'),'MONRRRR')
FROM DUAL
Helpful ? Need more stuff. just leave you comments.