Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images
Bewarse Talk Discussion Board * Archives - 2016 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through February 08, 2016 * Scripting experts < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124718
Registered: 06-2011
Posted From: 204.194.77.3
Posted on Friday, February 05, 2016 - 3:04 pm:    Edit Post Delete Post Print Post
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")
Top of pagePrevious messageNext messageBottom of page Link to this message

Jaffaa
Mudiripoyina Bewarse
Username: Jaffaa

Post Number: 23479
Registered: 03-2008
Posted From: 204.14.236.152
Posted on Thursday, February 04, 2016 - 11:26 pm:    Edit Post Delete Post Print Post
Nalla_baalu:

correct schema and table access chesthunnavemo chodu
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124715
Registered: 06-2011
Posted From: 204.194.77.3
Posted on Thursday, February 04, 2016 - 4:05 pm:    Edit Post Delete Post Print Post
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")
Top of pagePrevious messageNext messageBottom of page Link to this message

Tingari_xx
Celebrity Bewarse
Username: Tingari_xx

Post Number: 48649
Registered: 08-2006
Posted From: 205.157.66.4
Posted on Thursday, February 04, 2016 - 2:03 pm:    Edit Post Delete Post Print Post
Prasanth:



vere desam valla meeda hate crimes cheste aa desam pampi maree jail lo este kani budhi raadu. worst naa dash lu
Top of pagePrevious messageNext messageBottom of page Link to this message

Prasanth
Censor Bewarse
Username: Prasanth

Post Number: 76668
Registered: 03-2004
Posted From: 59.144.58.33
Posted on Thursday, February 04, 2016 - 2:02 pm:    Edit Post Delete Post Print Post
yeah...edho nadustaandhi case..

strip chesi parade cheyyaledhu ani karnataka minister told to centre
telugu biDDa (staying in bangalore and from vijayawada)
Top of pagePrevious messageNext messageBottom of page Link to this message

Tingari_xx
Celebrity Bewarse
Username: Tingari_xx

Post Number: 48648
Registered: 08-2006
Posted From: 205.157.66.4
Posted on Thursday, February 04, 2016 - 2:01 pm:    Edit Post Delete Post Print Post
Prasanth:



bglr ye kada vundedi. monna tanzania ammayi issue meeda em aina action tiskunnara?
Top of pagePrevious messageNext messageBottom of page Link to this message

Don
Mudiripoyina Bewarse
Username: Don

Post Number: 19383
Registered: 12-2004
Posted From: 50.204.44.26
Posted on Thursday, February 04, 2016 - 1:42 pm:    Edit Post Delete Post Print Post
select user, lastlogin from <table> where lastlogin < sysdate-30

idi work avvada?
Top of pagePrevious messageNext messageBottom of page Link to this message

Prasanth
Censor Bewarse
Username: Prasanth

Post Number: 76667
Registered: 03-2004
Posted From: 59.144.58.33
Posted on Thursday, February 04, 2016 - 1:35 pm:    Edit Post Delete Post Print Post
vammo IT side vellakapodam manchidaindi
telugu biDDa (staying in bangalore and from vijayawada)
Top of pagePrevious messageNext messageBottom of page Link to this message

Tingari_xx
Celebrity Bewarse
Username: Tingari_xx

Post Number: 48647
Registered: 08-2006
Posted From: 205.157.66.4
Posted on Thursday, February 04, 2016 - 1:27 pm:    Edit Post Delete Post Print Post
Nalla_baalu:



aithe veelu cheppinatlu aa diff lantidi use cheyyi

comparing to current date
Top of pagePrevious messageNext messageBottom of page Link to this message

Krishna_jilla
Kurra Bewarse
Username: Krishna_jilla

Post Number: 2229
Registered: 04-2015
Posted From: 143.115.155.55
Posted on Thursday, February 04, 2016 - 1:21 pm:    Edit Post Delete Post Print Post
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..
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124714
Registered: 06-2011
Posted From: 204.194.77.3
Posted on Thursday, February 04, 2016 - 1:19 pm:    Edit Post Delete Post Print Post
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")
Top of pagePrevious messageNext messageBottom of page Link to this message

Tingari_xx
Celebrity Bewarse
Username: Tingari_xx

Post Number: 48644
Registered: 08-2006
Posted From: 205.157.66.4
Posted on Thursday, February 04, 2016 - 12:25 pm:    Edit Post Delete Post Print Post
Nalla_baalu:



date > '01/01/2015' etc bhi try cheyachu anukunta, depending on the format.

chala years aindi nen touch chesi
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124713
Registered: 06-2011
Posted From: 204.194.77.3
Posted on Thursday, February 04, 2016 - 12:09 pm:    Edit Post Delete Post Print Post
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")
Top of pagePrevious messageNext messageBottom of page Link to this message

Mrbezawada
Pilla Bewarse
Username: Mrbezawada

Post Number: 135
Registered: 10-2011
Posted From: 205.172.134.228
Posted on Thursday, February 04, 2016 - 12:02 pm:    Edit Post Delete Post Print Post
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
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124712
Registered: 06-2011
Posted From: 204.194.77.3
Posted on Thursday, February 04, 2016 - 11:57 am:    Edit Post Delete Post Print Post
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")
Top of pagePrevious messageNext messageBottom of page Link to this message

Bewars
Kurra Bewarse
Username: Bewars

Post Number: 3087
Registered: 01-2008
Posted From: 23.123.25.129
Posted on Thursday, February 04, 2016 - 11:19 am:    Edit Post Delete Post Print Post
Users table ekkado mee database lo vuntundi kada. Query that table for users where sysdate() - last_login_date > 30.

Aa vidhamga munduku po..
Top of pagePrevious messageNext messageBottom of page Link to this message

Nalla_baalu
Censor Bewarse
Username: Nalla_baalu

Post Number: 124711
Registered: 06-2011
Posted From: 204.194.77.3
Posted on Thursday, February 04, 2016 - 11:06 am:    Edit Post Delete Post Print Post
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 MOVIEART--bemmi.adi
Aug 11th 2011 weight -- 84 kg; Aug 11th 2012 weight -- 88 kg; Aug 11th 2013 weight -- 80 kg; July 2015 -- 90 kilos (5'10")

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration