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 is process model?

2019


what are the errors,warnings in datastage

2762


What are the various kinds of containers available in datastage?

1100


I have a few records just I want to store data in to targets cycling way how?

2412


On which interface you will be working as a developer?

1101


how do u catch bad rows from OCI stage? And what CLI stands for?

2851


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1463


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?

2263


What is the difference between server job and parallel jobs?

1197


What are the functionalities of link partitioner?

1064


What are the types of jobs we have in datastage?

1119


Define Routines and their types?

1257


Name the different types of Lookups in Datastage?

1312


Can you explain players in datastage?

1245


Where do you see different stages in the designer?

1140