ADSM-L

Re: SQL question on date manipulation

2002-05-08 14:23:11
Subject: Re: SQL question on date manipulation
From: Alex Paschal <AlexPaschal AT FREIGHTLINER DOT COM>
Date: Wed, 8 May 2002 11:22:28 -0700
The server names have been changed to protect the innocent.

tsm: TSMSERVER>select filespace_name, min(archive_date) from archives where
nod
e_name='NODEA' group by filespace_name
ANR2963W This SQL query may produce a very large result table, or may
require a
significant amount of time to compute.

Do you wish to proceed? (Yes/No) y

FILESPACE_NAME                 Unnamed[2]
------------------     ------------------
\\nodea\c$                  2001-11-15
\\nodea\c$                  2001-11-15
                          17:40:04.000000
\\nodea\d$                  2001-11-15
                          17:14:44.000000
\\nodea\e$                  2001-09-14
                          11:13:35.000000
\\nodea\f$                  2001-11-15
                          17:31:25.000000

tsm: TSMSERVER>

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