convert yyyy mm dd to dd mm yyyy?

Question Posted / kkk

4 Answers
16394 Views
I also Faced
E-Mail Answers

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 is Cleanup Resources and when do you use it?

2 Answers

how to sort two columns in single job in datastage.

0 Answers TCS,

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

0 Answers Syntel,

what is mapping lookup

1 Answers

how to get the unique records on multiple columns by using sequential file stage only

3 Answers

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers Infotech,

how to validate the jobs

2 Answers IBM,

My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers Wipro,

how to run jon in unix back round process what is command use in runing a job?

2 Answers HSBC,

How to remove blank spaces from data?

3 Answers

If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers SLK Software,

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers

For more Data Stage Interview Questions Click Here