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

Differentiate between Join, Merge and Lookup stage?

1094


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1416


What are the types of hashed files in data stage

1108


how to implement scd2 in datastage 7.5 with lookup stage

5606


what is use of SDR function?

5174


Why do you need stage variables?

1181


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2186


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2234


Which algorithm you used for your hashfile?

1183


What is the difference between server job and parallel jobs?

1156


Can you explain kafka connector?

1312


What is datastage engine?

1180


What are the features of datastage flow designer?

1040


How one source columns or rows to be loaded in to two different tables?

1130


What are some prerequisites for datastage?

1100