Re: Select Statement for Archives
2000-07-11 11:20:56
I modified one of my select statements to check the years you requested.
The first display everything the second selected info in columns.
Dave T
select * from archives where archive_date>'1997-01-01 00:00:00.000000' and
archive_date<'1998-12-31 00:00:00.000000'
select node_name, filespace_name, ll_name, hl_name from archives where
archive_date>'1997-01-01 00:00:00.000000' and archive_date<'1998-12-31
00:00:00.000000'
|
|
|