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.
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