Solved

sysdate in FWM

Posted on 2008-10-16
2
378 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:muhammadaqeel
2 Comments
 
LVL 5

Accepted Solution

by:
welchb123 earned 500 total points
ID: 22740671
You can use the following calculation to return a date that is one year pervious to the current date.
_add_years ( current_date ,-1)
0
 

Author Comment

by:muhammadaqeel
ID: 22741449
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
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
How to increase the row limit in Jasper Server.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now