title: Table column has to be updated once its exceed in sqlite
body: <p>I am using 'sqlite' as a backend for the application. I have a table called 'student' and it has columns like student-name,student-id,student-year-of-join(with date and time),student-passed-out(with date and time),student-status. I insert student-name,student-id,student-year-of-join,student-passed-out in the starting itself. Once the student-passed-out from the college automatically the student-status has to be update to 'passed out'.</p>
  
  <p>I tried using the sqlite trigger,it's not working properly</p>
  
  <pre><code>create trigger student-passed-out after update on student when student-passed-out&lt;=datetime(now)begin update set candidate_status='Passed'
  </code></pre>
  
  <p>Here the student joins in different date and time. 
  What I want is once the student passed out time is expired or exceeded the status should change.</p>