Interested to Buy Any Domain ? << Click Here >> for more details...
I have prompt date prompt (from and to), country and city,
how to get data from jan1/2012 to jan31-2012.
- 2 Answers
- 6901 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / srini madhala
For example if you are in Mar2012:-
_add_months(sysdate,-2) which takes you into Jan2012.
After this convert the _add_months(sysdate,-2) to t0_char or to_date as required.
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What is catalog and types of catalogs in cagonos and which is better?
What are all types of Batches?
Which lifecycle we will use for reporting?
What are the ways to import data into catalog?
Can you define a catalog and types of catalogs in cognos?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
how to merge 2 crosstabs thans
--------------Diff b/w ODS and OLAP?
What are all the types of indexes in Cognos?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
Why is auto-regression used in forecasting used on cognos platform?
What is model filter?
Can you define a datastore in cognos?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
