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...

we have a column of int/varchar datatype,but when we run
the report we should get the date format
i.e., suppose date key is a query item consists of data as
20040105,20030503,20060410.......
output should be 5 jan 2004,3 may2003,10 apr
2006..........respectively.Can i knnow the answer

Answer Posted / sa

use Extract Function

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by ‘ibm predictive maintenance and quality’?

993


What do you mean by drill across?

1148


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

1037


i have one file i saved in csv how can i take these file into framework manager

2082


What is called Cognos powerplay?

1081


------------- How to identify the Revenue Column in Report?

2387


When we save a report in report studio with what extn it save?

1066


Which lifecycle we will use for reporting?

973


What is the report studio?

1018


what are slowly changing dimensions? Why we are used scd?

1125


what is the difference between native sql and cognos sql?

1002


What is difference between informatica power mart and power center?

1004


please please give me some banking calculations in framework manager.

2085


Can you define cube?

1031


What are the batches and it’s details?

973