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.

1 comment:

  1. This post tells you how you can get/show the first date of the month in Oracle Sql. The method of doing it is very simple and easy. You get the query in first go. It’s easy to learn. Just type the query and see the result.

    ReplyDelete