Hello all!
I have been trying to set up a select statement to look for all of the
error and warning messages within the past 24 hours. Here is what I have
come up with:
select date_time, msgno, message
from actlog
where severity='E' or severity='W'
and date_time>(current_timestamp-(1 day))
My problem is that it goes through the entire 14 days of the activity log
that I have and ignores the last statement. Any suggestions?
Thanks in advance!!!
**************************************
Joni Moyer
Systems Programmer
[EMAIL PROTECTED]
(717)975-8338
