Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

What is a Cube?

1148


Can you define set to be cardinality?

1011


What are all the components of Report Studio?

1099


What is defined as Query studio?

1103


What is cognos powerhouse?

1026


is cognos 7 is better than cognos 8

2165


What do you understand by the term 'aggregate advisor?'

964


what is the difference between filter and condition?

1066


Explain the difference between native sql and cognos sql?

1021


What is the difference between drill through, drill across?

1085


Actually we have 500 users when they run the report display the flage image related country user? How its possible?

2033


what is the main advantage of impromptu over cognos reportnet?

1039


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11744


How we check the errors before running the report?

999


hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

2193