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

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Print |

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

Answer: 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]")

May 05, 2007 22:26:42	#4
hanug	Member Since: June 2006 Total Comments: 24
RE: How to handle Date convertions in Datastage? Conve...
we can achieve this conversion using transformer stage conversion functions in PX. Hanu.

Back To Question