vikuba Posted January 29, 2013 Report Share Posted January 29, 2013 http://datawarehouse.ittoolbox.com/groups/technical-functional/ascential-l/how-to-convert-stringtodate-in-datastage-2979197 define your input not output [color=#000000][font=arial]Actually, very simple, it is based on your date input. For example, in my source database, it is defined the date as varchar(20) , so the date look like this "06/12/2008". When you transform the date into DB2 format in parallel job in datastage, then I need to specific what is my input date format, for example, stringtodate(06/12/2008, "%dd/%mm/%yyyy"). Then when it reach DB2, it will be in DB2 default format as this "2008-12-06". Basically defined your input and not output. [/font][/color] [color=#000000][font=arial]cheers,[/font][/color] 1 Link to comment Share on other sites More sharing options...
mrudhula99 Posted January 29, 2013 Report Share Posted January 29, 2013 lite.. plss dont waste time.. text file loo column motham same format undhii.. akkadeee replace chesaaa nakau kavalsina format lo ki... but later different dates unnappudu cheyyatanki logic try chestha.. after completing this.. thanks though Link to comment Share on other sites More sharing options...
kalyann Posted January 29, 2013 Report Share Posted January 29, 2013 [quote name='mrudhula99' timestamp='1359478684' post='1303195665'] lite.. plss dont waste time.. text file loo column motham same format undhii.. akkadeee replace chesaaa nakau kavalsina format lo ki... but later different dates unnappudu cheyyatanki logic try chestha.. after completing this.. thanks though [/quote] ur welcome re Link to comment Share on other sites More sharing options...
pavan_613 Posted January 29, 2013 Report Share Posted January 29, 2013 [quote name='mrudhula99' timestamp='1359434585' post='1303193782'] night thaagodhu... should drink before 8pm... thats it [/quote] Water ki kuda timing ah evaru Chepparu madam Link to comment Share on other sites More sharing options...
Silver_mani Posted January 29, 2013 Report Share Posted January 29, 2013 [quote name='Aamphat' timestamp='1359477445' post='1303195503'] all fellow DS users....DS easy ey naa? burra badhal kotvaalsina avsram emaina undhaa? naaku DS tool undi but i dont work wit tht..DS nunchi data vasthadi...aa data ni just test chestu untaaa anthey. DS nerchukundhaam ani feeling lo una....any suggestions? [b]ikkada evaru naaku backup ga untaaroo kuda cheppandi if possible[/b] [/quote] [img]http://www.gifsoup.com/view5/2418302/indra-intru-o.gif[/img] Link to comment Share on other sites More sharing options...
qwerty1204 Posted January 29, 2013 Author Report Share Posted January 29, 2013 [quote name='mrudhula99' timestamp='1359476280' post='1303195355'] situation enti ante... date lo naku 02JAN2013 ani untee nenu 2013-01-02 ani convert cheyyali... [/quote] edhi wrk avthundi chudu StringToDate(InputColumn,"%dd%mmm%yyyy") [img]http://i.imgflip.com/c9tm.gif[/img] Link to comment Share on other sites More sharing options...
mrudhula99 Posted January 29, 2013 Report Share Posted January 29, 2013 [quote name='arey ooo samba' timestamp='1359479354' post='1303195740'] edhi wrk avthundi chudu StringToDate(InputColumn,"%dd%mmm%yyyy") [img]http://i.imgflip.com/c9tm.gif[/img] [/quote] kani naku yyyy-mm-dd format lo kavali kadha... mmm endhuku mm ante 11 ani ravali.. NOV ani kadhu Link to comment Share on other sites More sharing options...
qwerty1204 Posted January 29, 2013 Author Report Share Posted January 29, 2013 [quote name='mrudhula99' timestamp='1359479462' post='1303195751'] kani naku yyyy-mm-dd format lo kavali kadha... mmm endhuku mm ante 11 ani ravali.. NOV ani kadhu [/quote] aa format input data ela vasthundoo ani.... output will always be YYYY-MM-DD format ee vasthundi 1 Link to comment Share on other sites More sharing options...
mrudhula99 Posted January 29, 2013 Report Share Posted January 29, 2013 naku excel lo format cells cheyyatam kudharatledhu..... 26APR2004:00:00:00 ila undhii data... naku 2004-03-26 ga convert cheyyali... plss help.. nenu Datastage gurinchi kadhu aduguthundhi. i need to do it in excel it self Link to comment Share on other sites More sharing options...
kalyann Posted January 29, 2013 Report Share Posted January 29, 2013 [quote name='mrudhula99' timestamp='1359490752' post='1303196996'] naku excel lo format cells cheyyatam kudharatledhu..... 26APR2004:00:00:00 ila undhii data... naku 2004-03-26 ga convert cheyyali... plss help.. nenu Datastage gurinchi kadhu aduguthundhi. i need to do it in excel it self [/quote] see under formulas/date Link to comment Share on other sites More sharing options...
vikuba Posted January 29, 2013 Report Share Posted January 29, 2013 [quote name='mrudhula99' timestamp='1359490752' post='1303196996'] naku excel lo format cells cheyyatam kudharatledhu..... 26APR2004:00:00:00 ila undhii data... naku 2004-03-26 ga convert cheyyali... plss help.. nenu Datastage gurinchi kadhu aduguthundhi. i need to do it in excel it self [/quote] try [font=Consolas, Menlo, Monaco,]Text(DateValue("1/2/2011"), "yyyy/mm/dd")[/font] http://stackoverflow.com/questions/4947490/convert-string-numeric-date-in-excel-to-a-date-formatted-object-using-only-formu Link to comment Share on other sites More sharing options...
kalyann Posted January 29, 2013 Report Share Posted January 29, 2013 http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP005204211.aspx Link to comment Share on other sites More sharing options...
Nisacharudu Posted January 29, 2013 Report Share Posted January 29, 2013 [quote name='mrudhula99' timestamp='1359490752' post='1303196996'] naku excel lo format cells cheyyatam kudharatledhu..... 26APR2004:00:00:00 ila undhii data... naku 2004-03-26 ga convert cheyyali... plss help.. nenu Datastage gurinchi kadhu aduguthundhi. i need to do it in excel it self [/quote] neenu okasari neeku solution pm pettinuttu gurthu Link to comment Share on other sites More sharing options...
mrudhula99 Posted January 29, 2013 Report Share Posted January 29, 2013 [quote name='Nisacharudu' timestamp='1359491209' post='1303197050'] neenu okasari neeku solution pm pettinuttu gurthu [/quote] yeah.. timestamp to date convert cheyyali.... podhuna nundii same work chesthunna... elaa cheyyaloo ardham avvatla.. maa lead emo.. do you know excel ani adigi velladu... Link to comment Share on other sites More sharing options...
vikuba Posted January 29, 2013 Report Share Posted January 29, 2013 if you are tryin to convert timestamp to date try this [url="http://www.asim.pk/2011/02/17/converting-unix-timestamp-to-date-and-time-in-excel/"]http://www.asim.pk/2...-time-in-excel/[/url] http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/ Link to comment Share on other sites More sharing options...
Recommended Posts