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

convert yyyy mm dd to dd mm yyyy?

Answer Posted / vivek nigam

If the datatype of the input is date then you need to
convert it to Char and the you can formulate it to Date
with the new format.

to_date(to_char(<Input Field>,'dd-m-yyyy'))

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the main differences you have observed between 7.x and 8.x version of datastage?

1072


Define data aggregation?

1084


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2195


What is the difference between datastage and informatica?

1097


Describe link sort?

995


How many types of views are there in a datastage director?

1272


What is a quality stage in datastage tool?

1063


How a source file is populated?

1049


How many types of stage?

1164


What are orabulk and bcp stages?

1110


How many types of hash files are there?

1163


How can one find bugs in job sequence?

1370


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4179


What are the processing stages?

1085


in oracle target stage when we use load option and when we use upsert option?

2262