The Events table is an odd duck (remember that SQL is a meta layer on top of a 
B-tree db in TSMv4,5) where performing a function on its timestamps will cause 
your quandry.  Instead, try a construct like:
  select * from events where scheduled_start <= (current_timestamp-12 hours)

    Richard Sims

On Mar 26, 2010, at 1:22 PM, Guenther Bergmann wrote:

> Hi TSMers,
> 
> If i do:
> q event * *  begind=today-1
> i get a lot of output for events that happened yesterday.
> 
> If i issue:
> select * from events where days(current_timestamp)-days(scheduled_start)>1
> 
> i get no results. Can someone explain the difference? What does q event do 
> other than selecting information from the events table?
> 
> Thanks in advance
> 
> regards Günther
> 
> -- 
> Guenther Bergmann, Am Kreuzacker 10, 63150 Heusenstamm, Germany
> Guenther_Bergmann at gbergmann dot de