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

Rate this post by selecting a number. 1 is the worst and 5 is the best.

    (Worst)    1    2    3    4    5     (Best)

Author Message
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

Rating: N/A
Votes: 0

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..

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