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:[EMAIL PROTECTED]
> 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
Rechenzentrum der | Fax : (++49)711/682357
Universität Stuttgart (RUS) | Email : [EMAIL PROTECTED]
Allmandring 30 |
70550 Stuttgart-Vaihingen |
WWW: http://servwww.rus.uni-stuttgart.de/ZSDNEU/People/frasch_de_noframe.html
