ADSM-L

Re: SQL question on date manipulation

2002-05-08 14:00:40
Subject: Re: SQL question on date manipulation
From: Alex Paschal <AlexPaschal AT FREIGHTLINER DOT COM>
Date: Wed, 8 May 2002 10:59:49 -0700
These should give you the information you're looking for.

select filespace_name, min(archive_date) from archives where
node_name='NODE' group by filespace_name

and

select filespace_name, max(archive_date) from archives where
node_name='NODE' group by filespace_name

Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail