Solved

sysdate in FWM

Posted on 2008-10-16
2
389 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

821 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