Manthrii Posted March 30, 2013 Report Posted March 30, 2013 [quote name='pandemkodi' timestamp='1364613503' post='1303511815'] output number vastada baa ina adi timestamp anta hours mins secs kuda diff kavalemo baa [/quote] 3-29-2013 5-10-1987 difference chesthe minus lo vasthundhi kadha baa.. so first year ni chesee... next month and migilina days tho difference chesthe workout ayyedhmo
mrudhula99 Posted March 30, 2013 Report Posted March 30, 2013 [quote name='arey ooo samba' timestamp='1364600578' post='1303511132'] I have an I/P column coming as TimeStamp in DataStage and I need to do a subtraction like this CurrentTimestamp - IncomingTimestamp from the column ela chestamu and result ee datatype lo vasthundi?? [/quote] months and days saparate ga years saparate ga differ cheye
pandemkodi Posted March 30, 2013 Report Posted March 30, 2013 [quote name='mrudhula99' timestamp='1364614068' post='1303511872'] months and days saparate ga years saparate ga differ cheye [/quote] nuvvinka batikey vunnava
accuman Posted March 30, 2013 Report Posted March 30, 2013 [quote name='pandemkodi' timestamp='1364614238' post='1303511892'] nuvvinka batikey vunnava [/quote] neeku pm ichha reply ivvu
qwerty1204 Posted March 30, 2013 Author Report Posted March 30, 2013 To all REQ edhi baa oka table lo ki CRTD_TIME ani for example 03/29/2013 8:15:00 AM ani store chesamu then oka 3 hrs ayaka aa record ni part of our processing..oka fiel lo ki testamu later..we need to do this subtraction curent time i.e. (03/29/2013 11:15:00 AM) - CRTD_TIME (03/29/2013 8:15:00 AM) cheyali so that naaku result emi teliyali ante if its less than 24 hours avnoo kadu oo teliyalii (currenttime - crtdtime < 24hrs)
mrudhula99 Posted March 30, 2013 Report Posted March 30, 2013 [quote name='arey ooo samba' timestamp='1364615148' post='1303511994'] To all REQ edhi baa oka table lo ki CRTD_TIME ani for example 03/29/2013 8:15:00 AM ani store chesamu then oka 3 hrs ayaka aa record ni part of our processing..oka fiel lo ki testamu later..we need to do this subtraction curent time i.e. (03/29/2013 11:15:00 AM) - CRTD_TIME (03/29/2013 8:15:00 AM) cheyali so that naaku result emi teliyali ante if its less than 24 hours avnoo kadu oo teliyalii (currenttime - crtdtime < 24hrs) [/quote] first year compare cheyye... difference unte >24 incase year same unte next month select cheyye ekkuva unte >24horus incase year same and month same and day ekkuva unte >24hours incase year same and month same and day same and hoours compare cheyyee... soo simple yaa....
qwerty1204 Posted March 30, 2013 Author Report Posted March 30, 2013 [quote name='mrudhula99' timestamp='1364614068' post='1303511872'] months and days saparate ga years saparate ga differ cheye [/quote] naa REQ loo hours level lo kavali
mrudhula99 Posted March 30, 2013 Report Posted March 30, 2013 [quote name='arey ooo samba' timestamp='1364615423' post='1303512025'] naa REQ loo hours level lo kavali [/quote] [size=4] [/size]
qwerty1204 Posted March 30, 2013 Author Report Posted March 30, 2013 [quote name='mrudhula99' timestamp='1364615347' post='1303512016'] first year compare cheyye... difference unte >24 incase year same unte next month select cheyye ekkuva unte >24horus incase year same and month same and day ekkuva unte >24hours incase year same and month same and day same and hoours compare cheyyee... soo simple yaa.... [/quote] DSX PM plzzzz
mrudhula99 Posted March 30, 2013 Report Posted March 30, 2013 [quote name='arey ooo samba' timestamp='1364615663' post='1303512039'] DSX PM plzzzz [/quote] [img]https://sphotos-a.xx.fbcdn.net/hphotos-frc1/402606_530579603647789_120458133_n.jpg[/img]
mrudhula99 Posted March 30, 2013 Report Posted March 30, 2013 [quote name='arey ooo samba' timestamp='1364615663' post='1303512039'] DSX PM plzzzz [/quote] example job ledhu.. kani process chepthunna kadha
qwerty1204 Posted March 30, 2013 Author Report Posted March 30, 2013 [quote name='mrudhula99' timestamp='1364615821' post='1303512052'] example job ledhu.. kani process chepthunna kadha [/quote] naaku aritipandu tokka tesi..pandu tinipinchee level edyna unte cheppava
mrudhula99 Posted March 30, 2013 Report Posted March 30, 2013 [quote name='arey ooo samba' timestamp='1364615977' post='1303512066'] naaku aritipandu tokka tesi..pandu tinipinchee level edyna unte cheppava [/quote] [size=4] [/size]
qwerty1204 Posted March 30, 2013 Author Report Posted March 30, 2013 [quote name='pandemkodi' timestamp='1364613733' post='1303511838'] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]The difference can only be second..and integer is datatype[/background][/size][/font][/color] [size=4][url="http://www.dsxchange.com/viewtopic.php?p=351854&sid=90a7d9cabaf9f42a4e0d50f6b599f896"]http://www.dsxchange...e0d50f6b599f896[/url][/size] [size=4]ee[pi link choodu bayya[/size] [/quote] aa link lo ee function edho undi baa [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]secondssincefromtimestamp function[/background][/size][/font][/color] [color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][background=rgb(234, 237, 244)]nxt week try chestha[/background][/size][/font][/color]
pandemkodi Posted March 30, 2013 Report Posted March 30, 2013 [quote name='mrudhula99' timestamp='1364615347' post='1303512016'] first year compare cheyye... difference unte >24 incase year same unte next month select cheyye ekkuva unte >24horus incase year same and month same and day ekkuva unte >24hours incase year same and month same and day same and hoours compare cheyyee... soo simple yaa.... [/quote] idantha enduku mundey day chestey telustadiga
Recommended Posts