Hey Everyone, I've been trying to get the proper output of archived data for a particular node, but I keep getting hung up on the archive_date parameter and was wondering if anyone could help out?
I am trying to get information on all archived data for the following: node_name=fjsu101 owner=appb2b filespace_id=11 Between the dates of 05/01/2009 & 05/02/2009 I was trying: select * from archives where node_name='FJSU101' and owner='appb2b' and filespace_id=11 and date(archive_date) > 04/31/2009 as a starting point, but I'm still having no luck. Any suggestions are greatly appreciated!!!! Joni Moyer Storage Administrator III (717)302-9966 joni.mo...@highmark.com ________________________________ This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.
