| |
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, 2006 02:35:07 |
#3 |
| Sucheta |
Member Since: Visitor Total Comments: N/A |
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' |
| |
Back To Question | |
