View Single Post
  #8 (permalink)  
Old September 27th, 2007, 02:17 AM
Dharam Pal Sikhwal Dharam Pal Sikhwal is offline
Authorized User
 
Join Date: Dec 2006
Location: Mumbai, Maharastra, India.
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

u can also try by this one for mysql.

select *
from usertable
where lastlogin >= DATE_SUB(CURDATE(), INTERVAL 90 DAY)

if DATE_SUB() function is running on your mysql u can make query by using this.

Thanks.

Reply With Quote