Send me the select and I will tell you but it is probably adding the following:
where date_time >current_timestamp - 24 hours It is crucial to have the ">current_timestamp" together. -----Original Message----- From: David E Ehresman [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:09 AM To: [EMAIL PROTECTED] Subject: Activity log messages How would I modify the SELECT statement in the TSM supplied sample Q_MSG-SEV script to only return messages from the past 24 hours?
