<div>
but when I write &nbsp;[phyical layar]. [date_dim].[date] = _add_years ( current_date ,-1) its gives me an error<br />
date column contains date too....so wht change is needed to make date colum contains the current date only
</div>


but when I write  [phyical layar]. [date_dim].[date] = _add_years ( current_date ,-1) its gives me an error
date column contains date too....so wht change is needed to make date colum contains the current date only

<div>
<div class="content wysiwyg-content">
i want to do some calculation on the base of current date..e.g. to calculate late year dates....<br />
model.table.date= (to_number(extract(year from sysdate ) )-1<br />
<br />
I know im camparing year with date...but i want to hav dates of last year in one query item ...how can i do tht
</div>
</div>


i want to do some calculation on the base of current date..e.g. to calculate late year dates....
model.table.date= (to_number(extract(year from sysdate ) )-1

I know im camparing year with date...but i want to hav dates of last year in one query item ...how can i do tht

sysdate in FWM

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.