<div>
Yes, you are correct. I think i had wrong place of parenthesis for TO_CHAR. 
 
you are a genius!
</div>

Yes, you are correct. I think i had wrong place of parenthesis for TO_CHAR.

you are a genius!

<div>
don't need to_char at all, &nbsp;but if you were going to do that (and I don't recommend it) 
 
 
it would look something like 
 
 
&nbsp;to_date( '01-OCT-'||(to_char(sysdate,'yyyy')-1),'dd-MON-yyyy') 
 
 
or more formally 
 
to_date( '01-OCT-'||to_char((to_number(to_char(sysdate,'yyyy'))-1)),'dd-MON-yyyy') 

</div>

don't need to_char at all,  but if you were going to do that (and I don't recommend it)


it would look something like


 to_date( '01-OCT-'||(to_char(sysdate,'yyyy')-1),'dd-MON-yyyy')


or more formally

to_date( '01-OCT-'||to_char((to_number(to_char(sysdate,'yyyy'))-1)),'dd-MON-yyyy')


<div>
<div class="content wysiwyg-content">
I have a stock item table like this 
 
 
stock_item 
----------- 
stock_code &nbsp;varchar2(10) 
discontinued varchar2(1) 
date_discontined &nbsp;date 
 
I want to report on items that are not disconitnued or that have been discontinued this fiscal year only. I want to exclude any items discontinued previous fiscal year or before. 
 
Disconitnued = 'Y' 
Not discontinued = NULL 
 
What is the best sql for that. I was thinking of somethig like this 
 
select stock_code from stock_item where discontinued IS NULL OR (discontinued='Y' and date_discontinued &gt;= '01-OCT-'||to_char(to_char(trunc(sysdate('YYYY'))-1) 
 
since there is no function that subtracts 3 months from 1st day of year. 
 
ADD_MONTHS only adds months. 

</div>
</div>

I have a stock item table like this


stock_item
-----------
stock_code  varchar2(10)
discontinued varchar2(1)
date_discontined  date

I want to report on items that are not disconitnued or that have been discontinued this fiscal year only. I want to exclude any items discontinued previous fiscal year or before.

Disconitnued = 'Y'
Not discontinued = NULL

What is the best sql for that. I was thinking of somethig like this

select stock_code from stock_item where discontinued IS NULL OR (discontinued='Y' and date_discontinued >= '01-OCT-'||to_char(to_char(trunc(sysdate('YYYY'))-1)

since there is no function that subtracts 3 months from 1st day of year.

ADD_MONTHS only adds months.


FiscalYearDateQuerrySQL

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.

Oracle Database

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.