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 --- ---
