Hi Andreas,

try the following statement:

select servername,nodename,date_time from actlog
where (cast((current_timestamp-date_time)hours as integer)>1)

Hope it works.

Regards
Hermann Frasch

Andreas Rensch wrote:

> Hi,
>
> how can i code a select statement, which gives me all nodename related
> events from the actlog and the last hour?
>
> The "current-time-1" is not the right statement.
>
> select servername,nodename,date_time from actlog where
> date_time='current-time-1'
>
> mfg / regards
>
> andreas rensch / rz-qs
> tel : +49(0)6171 66 3692 / fax : +49(0)6171 66 7500 3692 / mobil : +49(0)172
> 6649 016 / mailto:renscha AT alte-leipziger DOT de
> Alte Leipziger Lebensversicherung aG - Alte Leipziger Platz 1 - D 61440
> Oberursel - http://www.alte-leipziger.de
>
> > Christmas is weird. It's the only time of year when we love to sit in
> > front of a dead tree and eat candy out of our socks.
> >

--
Hermann Frasch               | Tel.  : (++49)711/685 5952
Hermann Frasch               | Tel.  : (++49)711/685 5952
Rechenzentrum der            | Fax   : (++49)711/682357
Universität Stuttgart (RUS)  | Email : frasch AT rus.uni-stuttgart DOT de
Allmandring 30               |
70550 Stuttgart-Vaihingen    |
WWW: http://servwww.rus.uni-stuttgart.de/ZSDNEU/People/frasch_de_noframe.html