Solved

sysdate in FWM

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

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…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

832 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