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
       alazarev AT itg.uiuc DOT edu | (217)244-1565 | www.itg.uiuc.edu
---                                                               ---