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
|