Hi, Jeff. How about...
select message from actlog where msgno in (2578,2571,whatever) and date_time
> cast((current_date - (1 day)) as timestamp) + (17 hours)) and date_time <
(cast((current_date as timestamp) + (8 hours))
Note: YUCK
I couldn't find a table for events. If it's possible, I would suggest
sticking with the q ev and parsing it using Perl or even awk/cut. It'd be
easier than trying to figure out which actlog messages mean what as far as
the events table goes.
Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
(503) 745-5091 fax
-----Original Message-----
From: Jeff Connor [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 04, 2000 7:17 AM
To: [EMAIL PROTECTED]
Subject: Quick SQL syntax question
Can anyone tell me the equivalent SQL command to:
Q EV * * begind=-1 begint=17:00 endd=today endt=08:00
I'm struggling with the date/time range calculation.
Thanks,
Jeff Connor
Niagara Mohawk Power Corp.
