pandemkodi Posted April 26, 2012 Report Share Posted April 26, 2012 [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][left]to get the different beteween two dates you can use the Iconv function [/left][/size][/font][/color] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][left]Iconv(DataEnd, "D/E") - Iconv(DataStart, "D/E")[/left][/size][/font][/color] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][left]copy from dsx[/left][/size][/font][/color] Link to comment Share on other sites More sharing options...
Silver_mani Posted April 27, 2012 Report Share Posted April 27, 2012 [quote name='pandemkodi' timestamp='1335463986' post='1301692259'] [left]to get the different beteween two dates you can use the Iconv function[/left] [left][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3]Iconv(DataEnd, "D/E") - Iconv(DataStart, "D/E")[/size][/font][/color][/left] [left][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3]copy from dsx[/size][/font][/color][/left] [/quote] Iconv,Oconv parallel lo vundavu kada baa Link to comment Share on other sites More sharing options...
pandemkodi Posted April 27, 2012 Report Share Posted April 27, 2012 [quote name='Silver_mani' timestamp='1335490155' post='1301695054'] Iconv,Oconv parallel lo vundavu kada baa [/quote] yup Link to comment Share on other sites More sharing options...
Silver_mani Posted April 27, 2012 Report Share Posted April 27, 2012 Nenu SQL lo raaskunna kaka .....! datediff(datepart,date1,date2 ) .It works [img]http://lh6.ggpht.com/-S06hy4eXSHo/T4r_4iTFEwI/AAAAAAAAGUI/qgaGkUYuBh8/s150/PK.gif[/img]....Data stage lo kudaraledu ...evarikaina vsaste cheppandi Link to comment Share on other sites More sharing options...
pandemkodi Posted April 27, 2012 Report Share Posted April 27, 2012 [quote name='Silver_mani' timestamp='1335490644' post='1301695087'] Nenu SQL lo raaskunna kaka .....! datediff(datepart,date1,date2 ) .It works [img]http://lh6.ggpht.com/-S06hy4eXSHo/T4r_4iTFEwI/AAAAAAAAGUI/qgaGkUYuBh8/s150/PK.gif[/img] [/quote] sql lo work avvudhi mama but particular ga tool use chesi cheyyalantey Link to comment Share on other sites More sharing options...
Silver_mani Posted April 27, 2012 Report Share Posted April 27, 2012 [quote name='pandemkodi' timestamp='1335490711' post='1301695090'] sql lo work avvudhi mama but particular ga tool use chesi cheyyalantey [/quote] emo mama ...datastage lo konni try chesina ...raledu ... lite teeskunna ..... free time vunnappudu malli try cheyyali [img]http://lh6.ggpht.com/-S06hy4eXSHo/T4r_4iTFEwI/AAAAAAAAGUI/qgaGkUYuBh8/s150/PK.gif[/img] Link to comment Share on other sites More sharing options...
pandemkodi Posted May 4, 2012 Report Share Posted May 4, 2012 babulu help kaavali flat file lo evary row end ki control M char vastondi daanni ela remove cheyyali cheppandi plz konchem urgent dsxchange try chesa but avi workout avvtley Link to comment Share on other sites More sharing options...
qwerty1204 Posted May 4, 2012 Author Report Share Posted May 4, 2012 [quote name='pandemkodi' timestamp='1336153607' post='1301739084'] babulu help kaavali flat file lo evary row end ki control M char vastondi daanni ela remove cheyyali cheppandi plz konchem urgent dsxchange try chesa but avi workout avvtley [/quote] COnvert function use chesi cheyachi emo chudu baa...aa control M symbol corresponding ASCII value tho convet function use cheyii like this Convert(char(number),"", input_column_name) Link to comment Share on other sites More sharing options...
pandemkodi Posted May 4, 2012 Report Share Posted May 4, 2012 [quote name='arey ooo samba' timestamp='1336153902' post='1301739112'] COnvert function use chesi cheyachi emo chudu baa...aa control M symbol corresponding ASCII value tho convet function use cheyii like this Convert(char(number),"", input_column_name) [/quote] aa number entio baa control M vachey place aa Link to comment Share on other sites More sharing options...
qwerty1204 Posted May 4, 2012 Author Report Share Posted May 4, 2012 [quote name='pandemkodi' timestamp='1336154131' post='1301739128'] aa number entio baa control M vachey place aa [/quote] try 13 in that number place baa [url="http://www.unix-manuals.com/refs/misc/ascii-table.html"]http://www.unix-manuals.com/refs/misc/ascii-table.html[/url] look into this link..might be helpful Link to comment Share on other sites More sharing options...
pandemkodi Posted May 4, 2012 Report Share Posted May 4, 2012 [quote name='arey ooo samba' timestamp='1336155252' post='1301739199'] try 13 in that number place baa [url="http://www.unix-manuals.com/refs/misc/ascii-table.html"]http://www.unix-manu...scii-table.html[/url] look into this link..might be helpful [/quote] thanks baa i will try this Link to comment Share on other sites More sharing options...
pandemkodi Posted May 4, 2012 Report Share Posted May 4, 2012 [quote name='pandemkodi' timestamp='1336156242' post='1301739279'] thanks baa i will try this [/quote] mma nit working mama oka file lo konni control M vunnai konni records ki levu Link to comment Share on other sites More sharing options...
RE8EL Posted May 4, 2012 Report Share Posted May 4, 2012 Vachesa.....koncham late ayindi guys...office lo heavy traffic.... (null) Link to comment Share on other sites More sharing options...
dalapathi Posted May 4, 2012 Report Share Posted May 4, 2012 [quote name='pandemkodi' timestamp='1336153607' post='1301739084'] babulu help kaavali flat file lo evary row end ki control M char vastondi daanni ela remove cheyyali cheppandi plz konchem urgent dsxchange try chesa but avi workout avvtley [/quote] control M antye endho teliyadhu akanie........okasaari extra line vasthuntey....idhi vaadinaa.........idhi okasaari ichi chuudu..... convert(char(9):char(10):char(13),'',InputColoumn) so, induloo may be ee muditlo edho okati vaadalanukuntaa.........char 9 ooh 10 ooh 13 ooh...... Link to comment Share on other sites More sharing options...
pandemkodi Posted May 4, 2012 Report Share Posted May 4, 2012 [quote name='dalapathi' timestamp='1336159430' post='1301739660'] control M antye endho teliyadhu akanie........okasaari extra line vasthuntey....idhi vaadinaa.........idhi okasaari ichi chuudu..... convert(char(9):char(10):char(13),'',InputColoumn) so, induloo may be ee muditlo edho okati vaadalanukuntaa.........char 9 ooh 10 ooh 13 ooh...... [/quote] nenu ippudu char(13) use chesa mama but not working adi actual gaa nenu string to decimal marchaley oka str ni so adi target lo zeros istondi endukantey daani tarvata control M char vunnai so naaku control M remove kaavaaley konni rows ki control M ledu malli Link to comment Share on other sites More sharing options...
Recommended Posts