Answer Detail: RE: How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?<br/><b

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

June 06, 2005 01:21:15	#1
sasi	Member Since: Visitor Total Comments: N/A
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

Back To Question