| |
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]")
|
| September 09, 2005 10:26:19 |
#2 |
| aslam |
Member Since: Visitor Total Comments: N/A |
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]") . |
| |
Back To Question | |
