DataStage - How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 15 of 390

How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?

We use a) "Iconv" function - Internal Convertion.
b) "Oconv" function - External Convertion.

Function to convert mm/dd/yyyy format to yyyy-dd-mm is
Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]")

Total Answers and Comments: 4

Last Update: May 06, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 27, 2005 01:21:15

sasi

RE: How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?

fine
but what is the difference between diff.types of hash files

Is this answer useful? Yes | No

September 18, 2005 10:26:19

aslam

RE: How to handle Date convertions in Datastage? Conve...

Here is the right conversion:

Function to convert mm/dd/yyyy format to yyyy-dd-mm is
Oconv(Iconv(Filedname D/MDY[2 2 4] ) D-YDM[4 2 2] ) .

Is this answer useful? Yes | No

June 05, 2006 02:35:07

Sucheta

RE: How to handle Date convertions in Datastage? Conve...

ToChar( date format )

This shuld work in format specify which format u want i.e 'yyyy-dd-mm'

Is this answer useful? Yes | No

May 06, 2007 22:26:42

hanug

Member Since: June 2006 Contribution: 24

RE: How to handle Date convertions in Datastage? Conve...

we can achieve this conversion using transformer stage conversion functions in PX.

Hanu.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank