Hi,
My input data format is varchar:(08August2011)
i want to convert out put as date (2011-08-08)
i had written logic
String To Date((Left(col,2):-:(If ((col,3,3)="JAN" Then "01" Else if (col,3,3)="Feb" Then "02"........upto December i had written and :-:Right(col,4),"%dd-%mm-%yyyy")
its working fine .
is there any option to handle this insted of writing this much of big syntax
Thanks
TYPECONVERSION
Moderators: chulett, rschirm, roy
I'm not at a DataStage session where I can confirm, but think that should work.
Code: Select all
StringToDate(In.Col,"%dd%mmmm%yyyy")