?
Solved

sysdate in FWM

Posted on 2008-10-16
2
Medium Priority
?
392 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Accepted Solution

by:
welchb123 earned 2000 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

770 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