Author |
Message |
Nalla_baalu
Censor Bewarse Username: Nalla_baalu
Post Number: 124718 Registered: 06-2011 Posted From: 204.194.77.3
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, February 05, 2016 - 3:04 pm: |
|
login date < sysdate() - 60 ani isthe pani cheyyaledhu login date < INTERVAL 60 day ani isthe pani chesindhi output text file lo ki thosaaa ippudu aa text ni html lo convert cheyyamantunnaru denemma jeevithaam .... Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
|
Jaffaa
Mudiripoyina Bewarse Username: Jaffaa
Post Number: 23479 Registered: 03-2008 Posted From: 204.14.236.152
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 11:26 pm: |
|
Nalla_baalu:
correct schema and table access chesthunnavemo chodu |
Nalla_baalu
Censor Bewarse Username: Nalla_baalu
Post Number: 124715 Registered: 06-2011 Posted From: 204.194.77.3
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 4:05 pm: |
|
Don:select user, lastlogin from <table> where lastlogin < sysdate-30 idi work avvada?
ya idhe chesaanu annai ...it's working for my teammates naaku em qeury raasina 52 rows ee vasthunnai .... filter pettina theesesina ....endho gola ee Databases ...pakkanodu same query raasthunte it is giving him proper results Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
|
Tingari_xx
Celebrity Bewarse Username: Tingari_xx
Post Number: 48649 Registered: 08-2006 Posted From: 205.157.66.4
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 2:03 pm: |
|
Prasanth:
vere desam valla meeda hate crimes cheste aa desam pampi maree jail lo este kani budhi raadu. worst naa dash lu |
Prasanth
Censor Bewarse Username: Prasanth
Post Number: 76668 Registered: 03-2004 Posted From: 59.144.58.33
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 2:02 pm: |
|
yeah...edho nadustaandhi case.. strip chesi parade cheyyaledhu ani karnataka minister told to centre telugu biDDa (staying in bangalore and from vijayawada)
|
Tingari_xx
Celebrity Bewarse Username: Tingari_xx
Post Number: 48648 Registered: 08-2006 Posted From: 205.157.66.4
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 2:01 pm: |
|
Prasanth:
bglr ye kada vundedi. monna tanzania ammayi issue meeda em aina action tiskunnara? |
Don
Mudiripoyina Bewarse Username: Don
Post Number: 19383 Registered: 12-2004 Posted From: 50.204.44.26
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 1:42 pm: |
|
select user, lastlogin from <table> where lastlogin < sysdate-30 idi work avvada? |
Prasanth
Censor Bewarse Username: Prasanth
Post Number: 76667 Registered: 03-2004 Posted From: 59.144.58.33
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 1:35 pm: |
|
vammo IT side vellakapodam manchidaindi telugu biDDa (staying in bangalore and from vijayawada)
|
Tingari_xx
Celebrity Bewarse Username: Tingari_xx
Post Number: 48647 Registered: 08-2006 Posted From: 205.157.66.4
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 1:27 pm: |
|
Nalla_baalu:
aithe veelu cheppinatlu aa diff lantidi use cheyyi comparing to current date |
Krishna_jilla
Kurra Bewarse Username: Krishna_jilla
Post Number: 2229 Registered: 04-2015 Posted From: 143.115.155.55
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 1:21 pm: |
|
Nalla_baalu:select user, lastlogin from <table> where lastlogin > 30 days > anedhi qrithimetic operations ki anukunta kada ...dates ela set chesthaam
nen aithe ila chesa annai.. for db2 select * from table where updatedTime <= current_date - 50 Days .. na requirement less than 50 days update avvani messages pick cheskovali.. |
Nalla_baalu
Censor Bewarse Username: Nalla_baalu
Post Number: 124714 Registered: 06-2011 Posted From: 204.194.77.3
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 1:19 pm: |
|
Tingari_xx:date > '01/01/2015' etc bhi try cheyachu anukunta, depending on the format.
hmm kaani annai everyday report raavali anta maa mails ki >01/01/2015 ante ... 30 days anedhi varthinchadhu kada Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
|
Tingari_xx
Celebrity Bewarse Username: Tingari_xx
Post Number: 48644 Registered: 08-2006 Posted From: 205.157.66.4
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 12:25 pm: |
|
Nalla_baalu:
date > '01/01/2015' etc bhi try cheyachu anukunta, depending on the format. chala years aindi nen touch chesi |
Nalla_baalu
Censor Bewarse Username: Nalla_baalu
Post Number: 124713 Registered: 06-2011 Posted From: 204.194.77.3
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 12:09 pm: |
|
Mrbezawada:Date Diff Functions untay...mee Database ni batti ee function use cheyalo google cheskondi
vokey Mysql vaaduthunnam choodali ela cheyyalo....malli idantha ayyaka oka script allali daani chuttantha Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
|
Mrbezawada
Pilla Bewarse Username: Mrbezawada
Post Number: 135 Registered: 10-2011 Posted From: 205.172.134.228
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 12:02 pm: |
|
Nalla_baalu:yeah alane chedhaam anukunta ....sql kuda peddaga raadhu idhe naaa select user, lastlogin from <table> where lastlogin > 30 days > anedhi qrithimetic operations ki anukunta kada ...dates ela set chesthaam
Date Diff Functions untay...mee Database ni batti ee function use cheyalo google cheskondi Bezawada Bewarse Batchey
|
Nalla_baalu
Censor Bewarse Username: Nalla_baalu
Post Number: 124712 Registered: 06-2011 Posted From: 204.194.77.3
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 11:57 am: |
|
yeah alane chedhaam anukunta ....sql kuda peddaga raadhu idhe naaa select user, lastlogin from <table> where lastlogin > 30 days > anedhi qrithimetic operations ki anukunta kada ...dates ela set chesthaam Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
|
Bewars
Kurra Bewarse Username: Bewars
Post Number: 3087 Registered: 01-2008 Posted From: 23.123.25.129
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 11:19 am: |
|
Users table ekkado mee database lo vuntundi kada. Query that table for users where sysdate() - last_login_date > 30. Aa vidhamga munduku po.. |
Nalla_baalu
Censor Bewarse Username: Nalla_baalu
Post Number: 124711 Registered: 06-2011 Posted From: 204.194.77.3
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, February 04, 2016 - 11:06 am: |
|
Maaku oka webpage untadhi.... Naaku admin access undhi kabatti.... I can manage all users ...Users tab ki elthe ID email Last Login ani undhi I have to write a script where I should pull out users who have not logged in for more than 30 days... asalu ekkad nundi modhalu pettali idhi Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")
|