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")
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>