Monday, September 26, 2011

How to Show/ Get First Date of a Month in Oracle Sql ? (Part-2)

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.