tsm: XXXXXX>select node_name as "Hostname", filespace_name as "Filespace", date(backup_end) as "Last completed backup" from filespaces where backup_end<current_timestamp-1 day or backup_end is null order by 3
The result of an SQL query against a table, is always another table. IN this case, "3" means to order using the 3rd column of the resulting query table. If you wanted to order by hostname, you would say "order by 1", since that's the first column you asked for. If I replace ALL references of backup_end with data(backup_end) it doesn't work either and gives the following error: ANR2904E Unexpected SQL key word token - 'DATE'. I go through the script, no matter what backup_end's are replaced with date(backup_end), I can't get it to work. Any other ideas? Thanks! Alex On Wed, 27 Aug 2003, Fred Johanson wrote: > Try ...date(backup_end) as ... > > > At 02:21 PM 8/27/2003 -0500, you wrote: > >I've got a tsm script which works fine, but I only want the date from > >backup_end table, not the time. Anyone know how to get the date only from > >backup_end? The time on it is not needed and adds to much clutter to the > >email. I can do it in perl, but there must be some way to do it in sql, > >which I prefer. Statement is below: > > > >select node_name as "Hostname", filespace_name as "Filespace", backup_end > >as "Last completed backup" from filespaces where > >backup_end<current_timestamp-1 day or backup_end is null order by > >backup_end > > > >Thanks in advance, > > > >Alex > >--- --- > > Alex Lazarevich | Systems Administrator | Imaging Technology Group > > Beckman Institute - University of Illinois > > [EMAIL PROTECTED] | (217)244-1565 | www.itg.uiuc.edu > >--- --- >
