View Single Post
  #7 (permalink)  
Old September 27th, 2007, 02:11 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

Hi melkin,

Actually i am using sql server.

I think for mysql this will work-

Select UserId
From User_Master
Where (TO_DAYS(lastlogin)-TO_DAYS(curdate())) between 90 and 120

Reply With Quote