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

convert yyyy mm dd to dd mm yyyy?

Question Posted / jerry

Answer Posted / jerry

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How will you move hashed file from one location to another location?

2137

How do u convert the columns to rows in datastage?

1175

What are the types of jobs we have in datastage?

1057

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3636

Explain entity, attribute and relationship in datastage?

1082

Explain usage analysis in datastage?

1143

How a server job can be converted to a parallel job?

1080

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2430

options available in sequence job to run,validate?

1294

Differentiate between data file and descriptor file?

1027

Does datastage support slowly changing dimensions ?

1093

Define data aggregation?

1083

in oracle target stage when we use load option and when we use upsert option?

2259

How do you register plug-ins?

954

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

2170