Hi to all

Try to run a select query on the actlog table for certain msgno in certain
period but got wrong result. Here my select command:
select nodename , msgno , substr(message,44,14) as "Message            "
from actlog where (msgno=4961 or msgno=4964) and date_time=CURRENT_TIMESTAMP
- 1 days

Without the date_time parameter I got what I want but for the entire period
I need to limit my query for the last 24 hours.

Please advise if possible ..........

Regards Robert Ouzen
E-mail: rouzen AT univ.haifa.ac DOT il