Jump to content


Database query to find last stop date


  • Please log in to reply
1 reply to this topic

#1 telecom engineer

telecom engineer

    Newbie

  • Members
  • Pip
  • 25 posts

Posted 29 September 2011 - 05:04 PM

dear all ,
i am working on CRM(Customer relationship manegement) and i need to find customers that last connected in 10 days for example (inactive customers)
i have a table with start date and stop date , can i run query to know who was inactive for the last 10 days (for example stop date would be 19-Sep)
i need to know if it is doable at least .

thank you
  • 0

#2 japet

japet

    Newbie

  • Members
  • Pip
  • 7 posts
  • Gender:Male

Posted 29 October 2011 - 06:50 PM

try this where clause... where to_date(sysdate, 'yyyy/mm/dd') - to_date(last_date, 'yyyy/mm/dd') > 10
  • 0





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users