select backup_end - only date?
2003-08-27 15:22:10
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
--- ---
|
|
|