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.moyer AT highmark DOT 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.