<div>
select trunc(sysdate,'yyyy'), trunc(sysdate,'mm') - 1 from dual
</div>


select trunc(sysdate,'yyyy'), trunc(sysdate,'mm') - 1 from dual

<div>
<div class="content wysiwyg-content">
I have a need to pull the first month of current year and then also pull the previous month end.<br />
<br />
Example: &nbsp;<br />
<br />
1/1/2013 - 7/31/2013<br />
<br />
I'm doing a parameter with a report and need to have this date automatically populated. &nbsp;I am able to get the end of month for last month. &nbsp;However, I can't seem to get the first month for the year at beginning of month.
</div>
</div>


I have a need to pull the first month of current year and then also pull the previous month end.

Example:  

1/1/2013 - 7/31/2013

I'm doing a parameter with a report and need to have this date automatically populated.  I am able to get the end of month for last month.  However, I can't seem to get the first month for the year at beginning of month.

SQL - First Month of Year and Last day of previous month.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.