Bill, Try this instead:
select * from summary where activity like 'BACKUP' and entity like 'DOCCM_DB2' and (current_timestamp - start_time) <= 72 hours Thanks & Regards, Ramakrishna Choudarapu -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill Dourado Sent: Monday, June 05, 2006 6:05 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SQL Help Importance: High Hi, What do I need to add to this SQL statement, to only list backups done in the last 3 days ? select * from backups where node_name = 'DOCCM_DB2' I have had several unsuccessful attempts . Thanks in Advance. Bill ******************************* Disclaimer ******************************* This email and any files transmitted with it contains privileged and confidential information and is intended for the addressee only. If you are not the intended recipient you must not disseminate, distribute or copy this email. Please notify the sender at once that you have received it by mistake and then delete it from your system. Any views expressed in this email are those of the sender and not necessarily those of ALSTEC or its associated companies. Whereas ALSTEC takes reasonable precautions to ensure this email is virus free, no responsibility will be accepted by it for any loss or damage whether direct or indirect which results from the contents of this email or its attachments. ALSTEC Group Limited - Registered in England No.3939840 - www.alstec.com Registered office: Cambridge Road, Whetstone, Leicester. LE8 6LH. England. Telephone: +44 (0)116 275 0750 -------------------------------------------------------- If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/ --------------------------------------------------------