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

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

convert yyyy mm dd to dd mm yyyy?

Question Posted / kkk

Answers were Sorted based on User's Feedback



convert yyyy mm dd to dd mm yyyy?..

Answer / 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

convert yyyy mm dd to dd mm yyyy?..

Answer / jerry

to_date(to_char(Field_Name,'dd-mm-yyyy'),'dd/mm/yyyy');

Is This Answer Correct ?    2 Yes 1 No

convert yyyy mm dd to dd mm yyyy?..

Answer / nish

Can also use ICONV

Is This Answer Correct ?    0 Yes 0 No

convert yyyy mm dd to dd mm yyyy?..

Answer / ashok

using field we can cut yyyy,mm,dd as separate and using
concat we can combine as dd mm yyyy

Is This Answer Correct ?    4 Yes 6 No

Post New Answer

More Data Stage Interview Questions

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

How do u call shellscript/Batch file from DS?

4 Answers   HP,

What are stage variables, derivations and constants?

0 Answers  

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

what is the main difference between sorragate key n primary key in one word

2 Answers  

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

what is a nodemap constraint

2 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories