<div>
note: you should better use the 1st of the month, and use yourfield &lt;&nbsp;1st_of_month.<br />
also, you should have the date in DATE date type, and not in VARCHAR2 data type...
</div>


note: you should better use the 1st of the month, and use yourfield < 1st_of_month.
also, you should have the date in DATE date type, and not in VARCHAR2 data type...

<div>
<div class="content wysiwyg-content">
i have a date in mm/dd/yyyy format. <br />
the date is always the end of the month. <br />
for example 7/31/2007<br />
i need to figure out what was the date at the end of the previous month ( i.e 06/30 2008). in mm/dd/yyyy format<br />
<br />
what is the oracl sql for this ?
</div>
</div>


i have a date in mm/dd/yyyy format. 
the date is always the end of the month. 
for example 7/31/2007
i need to figure out what was the date at the end of the previous month ( i.e 06/30 2008). in mm/dd/yyyy format

what is the oracl sql for this ?

Subtracting 1 month from a given date

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.