Re: SQL question on date manipulation
2002-05-08 14:00:40
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
|
<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
|
|
|