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 380

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