Re: SQL question on date manipulation
2002-05-08 14:23:11
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- SQL question on date manipulation, Jolliff, Dale
- Re: SQL question on date manipulation, Williams, Tim P {PBSG}
- Re: SQL question on date manipulation, Jolliff, Dale
- Re: SQL question on date manipulation, Cook, Dwight E
- Re: SQL question on date manipulation, Cook, Dwight E
- Re: SQL question on date manipulation, Alex Paschal
- Re: SQL question on date manipulation, Jolliff, Dale
- Re: SQL question on date manipulation, Jolliff, Dale
- Re: SQL question on date manipulation,
Alex Paschal <=
- Re: SQL question on date manipulation, Jolliff, Dale
|
|
|