using trunc, sysdate and add_months we can get the month start and end date
to get month start date
select trunc(sysdate, 'MM')as start_date from dual
>> to get month end date
select add_months(trunc(sysdate, 'MM'), 1) -1 as last_date from dual.
combine above two queries you will get the start and end date of the month
select trunc(sysdate,'MM') as start_date, add_months(trunc(sysdate,'MM'), 1) -1 as end_date from dual
Learn to Develop an iPhone or iPad App in 4 Weeks Learn the latest and greatest markup language in the market with Robin Nixon(HTML & HTML5) Now $29 Only(75% Off)
using trunc, sysdate and
Mon, 12/08/2008 - 19:31 — adminusing trunc, sysdate and add_months we can get the month start and end date
to get month start date
select trunc(sysdate, 'MM')as start_date from dual
>> to get month end date
select add_months(trunc(sysdate, 'MM'), 1) -1 as last_date from dual.
combine above two queries you will get the start and end date of the month
select trunc(sysdate,'MM') as start_date, add_months(trunc(sysdate,'MM'), 1) -1 as end_date from dual