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

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

What are the various kinds of containers available in datastage?

0 Answers  

What are orabulk and bcp stages?

0 Answers  

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,




6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment

3 Answers   TCS,

Highlight the main features of datastage?

0 Answers  

In Datastage, how you can fix the truncated data error?

0 Answers  

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

0 Answers   CGI,

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers  

How did you reconcile source with target?

3 Answers   HP,

For more Data Stage Interview Questions Click Here
Categories